EXPORT DATA WITH TAB SEPARATORS

  • Thread starter Thread starter SUB
  • Start date Start date
S

SUB

Hi all,

I am after a technique, either macro based on VBA where I
can tell access to use the tab character as the separator,
Access seems to always want to use a comma instead???
Cant seem to get Access to change over. Can anyone shed
some light on this?

cheers in advance

SUB
 
You can create an export specfication, that includes the definition of the
field delimiter character.

1. Choose Export from the File menu.
2. Enter a file name, and choose the Text type.
3. Click: Advanced.
4. Change the Field Delimiter to: {tab}
5. Click: Save As

Use that specification in your TransferText export.
 
I usually do the export manually, building a
specification. You can designate tab characters to use.
Once done, you can reference your table/query and
specification from a macro.
 
cheers allen,

spot on, its not very well documented in manuals I have
seen, but anyway, works fine now.

cheers

SUB
 
Back
Top