Access table conversion to tabdelimited format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've built a macro in Access 2000 and would like to know how to convert a
table made in the macro to tab delimited format and send it to another folder
on the c drive. I can do this manually using the File Export menu selections
but can only send it in text format from the macro.
Thanks
 
WayneMacro said:
I've built a macro in Access 2000 and would like to know how to convert a
table made in the macro to tab delimited format and send it to another
folder
on the c drive. I can do this manually using the File Export menu
selections
but can only send it in text format from the macro.
Thanks
Click to expand...

You need to create and save an export specification. In the export wizard
press the "Advanced" command button - the dialog that appears will allow you
to create and save a specification for exporting a tab-delimited text file,
which can in turn be used in your export macro.

Ed Metcalfe.
 
Back
Top