Tab delimited output (MS Access Database)

Tab delimited output
message from =?Utf-8?B?YW1iZXJzb2Z0?= on 15 May 2004
Hi, I'm trying to create a tab delimited file from some access tables. I need to insert a 'tab' into one of the columns in a table. Does anyone know how to do this? I've tried CTL+TAB but it doesn't work. Thanks in advance Garry

Ken Snell replied to =?Utf-8?B?YW1iZXJzb2Z0?= on 15 May 2004

Set up and save an export specification that contains tab as the delimiter.

(1) manually export the table via File | Export option (note that this
is how you also set up the export specification, using the Advanced button
located at the bottom left corner of the export wizard window);

OR

(2) use a macro to do the TransferText action;

OR

(3) use VBA to do the DoCmd.TransferText action.

Tom Wickerath replied to =?Utf-8?B?YW1iZXJzb2Z0?= on 15 May 2004

Hi Garry,

Print #1, "Hello" & vbTab & "Garry"
or
Print #1, "Hello" & Chr(9) & "Garry"

Tom
________________________________________

"ambersoft" <anonymous@discussions.microsoft.com> wrote in message
news:57752882-3C05-4FC3-9338-EA1C7ED95199@microsoft.com...

Hi,

I'm trying to create a tab delimited file from some access tables. I need to insert a 'tab' into
one of the columns in a table.

Does anyone know how to do this? I've tried CTL+TAB but it doesn't work.

Thanks in advance

Garry

Archived message: Tab delimited output (Microsoft Access Error Message)