Access table conversion to tabdelimited format

[WayneMacro]

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

 

[Ed Metcalfe]

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

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.