Tab delimited output

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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
 
Back
Top