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. TABLE ps ---> TABLE txt

3. saving a description to a access table field?

4. Vbscript convert RTF to Txt

5. Save Changes to .rtf file in a frameset

6. currently Save to .rtf using vbscript - Word object

7. save html code to txt file

8. Will EXCEL save as a REAL *.txt file ???

9. Save email in Inbox to TXT file

10. Saving/Loading Registry Subtree via TXT-File

11. Saving an XL File as a .txt file

12. Displaying Access Table, as a table in VBScript

 

 
Powered by phpBB® Forum Software