Hi,
  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