Tab delimited output

A

ambersoft

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
 
K

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>

ambersoft said:
Hi,

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

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
 
Top