
Save an access table to .txt and .rtf
Seems very close. When I use <%Response.ContentType =
"application/vnd.ms-excel"%>, it automatically gives the file rxtension .xls.
But when I use <%Response.ContentType = "application/msword"%>, it give the
extension .doc (I want it to be .rtf), and when I use <%Response.ContentType =
"text/plain"%>, it just show this file but not save it. Anything wrong.
Thank you.
Y.H. Duan
Quote:
> Hmmm. I wasn't aware that the Response.ContenType property actually
> reformatted data. I thought it was just basically a "hint" to the browser as
> to what to do with the incoming file. Did I misunderstand you?
> Anyway, if it helps, on my computers the mime type for plain text files is
> text/plain, and for *.rtf it's application/msword.
> Jeff
> > Thank you. The problem is I use ASP file to query the access 97 database.
> In
> > ASP we can use <%Response.ContentType = "application/vnd.ms-excel"%>
> > to save a file in excelformat. How can we do it to delimited ASCII Text
> > File(.txt) and a Rich Text Format File(.rtf)?
> > Y.H. Duan
> > > In Access 2000, you can use the OutputTo macro via the
> Access.Application
> > > automation object. This macro allows you to specify the output format as
> > > RTF, HTML, XLS, etc....
> > > Just keep an eye on performance if this is going to be heavily used.
> > > Jeff
> > > > Hi:
> > > > Can anybody tell me how to save the data of an access database into a
> > > > delimited ASCII Text File(.txt) and a Rich Text Format File(.rtf) by
> > > > using asp.
> > > > Your help is appreciated.