Tab delimited output

[Guest]

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 advanc

Garry

 

[Ken Snell]

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

Then use that export specification to do one of the following:

(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.



--
Ken Snell
<MS ACCESS MVP>

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.

 

[Tom Wickerath]

Hi Garry,

You should be able to use either the intrinsic constant vbtab or chr(9). For example:

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

Tom
________________________________________


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