Export Access table programmaticlly

[guttorm]

Hello all,
i need a way to replicate the export function from the
table menu item. what i need is a tab delimited, no quotes
and column headers. when i try to create a macro to do
this i donot get the headers. I need the headers.

tks
wayne

 

[Steve Schapel]

Wayne,

Presumably you need a TransferText macro.

Run through the File|Export process manually, and when you get to the
last screen of the export wizard, click the Advanced button, and save
the Specification. Then, when you make your TransferText macro, put
this in the Specification Name argument.