Export an Access table to a text (fixed width) file 
Author Message
 Export an Access table to a text (fixed width) file

  I need to Export one table from my Access database into a Text (fixed
width) file.  To do it in Access Basic it would be:

DoCmd TransferText A_EXPORTFIXED, "Report Output", "Report","C:\Rpt1.txt"

I need to find a way to do this beside using a dde link to Access, since
not all clients have Access.  It is important that it is fixed width,
since some fields contain spaces based on the field length.  
Another program will read in this fixed width text file.... why....
because the other company said thats the way they will allow imports.

Thanks for your help.


                            LIFE LION Airmedical Services
              Penn State Univesity Hospital, M.S. Hershey Medical Center

Tue, 07 Jul 1998 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Help! Exporting table to Fixed-Width Text file

2. Converting a Fixed Width text file to an access database table

3. Export to Fixed-Width Text File

4. How to export a table with a fix width

5. ACCESSING: Fixed Width Text Files

6. HELP:Fixed-Width Text File to Access 97 DB

7. Fixed-Width Import/Export Specification File

8. Output to a fixed-width text file

9. Importing Fixed-Width text files

10. Printing a fixed width text file to dot matrix printer

11. Importing Fixed Width Text Files

12. get data from fixed-width text file


Powered by phpBB® Forum Software