Save an access table to .txt and .rtf 
Author Message
 Save an access table to .txt and .rtf

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.



Fri, 10 May 2002 03:00:00 GMT  
 Save an access table to .txt and .rtf
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


Quote:
> 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.



Sat, 11 May 2002 03:00:00 GMT  
 Save an access table to .txt and .rtf
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

Quote:

> 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.



Sat, 11 May 2002 03:00:00 GMT  
 Save an access table to .txt and .rtf
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


Quote:
> 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.



Sun, 12 May 2002 03:00:00 GMT  
 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.



Sun, 12 May 2002 03:00:00 GMT  
 Save an access table to .txt and .rtf

You can try this, but IE may ignore you anyway...

...
Response.AddHeader "Content-Disposition", "attachment;filename=blahblah.rtf"
...

--
Michael Harris

  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


  > 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.
  > > > >
  > >



Sun, 12 May 2002 03:00:00 GMT  
 Save an access table to .txt and .rtf

Thank you. It works.

Y.H. Duan

Quote:

> You can try this, but IE may ignore you
> anyway... ...Response.AddHeader "Content-Disposition",
> "attachment;filename=blahblah.rtf"...
> --
> Michael Harris



>      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


>      > 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.



Sun, 12 May 2002 03:00:00 GMT  
 
 [ 7 post ] 

 Relevant Pages 

1. Save an access table to .txt and .rtf

2. save file as .txt or as .rtf in rich text box

3. save file as .txt or as .rtf in rich text box

4. TABLE ps ---> TABLE txt

5. transfer .txt to my existing table in Ms Access

6. export access table to txt file

7. RTF save using ADO / COM to Access / SQL database

8. Saving .rtf in an access database

9. Export Pocket Access table to TXT file?

10. saving a description to a access table field?

11. Storing RTF text in Access table

12. Tables in RTF or Access to Word functions

 

 
Powered by phpBB® Forum Software