EXPORT DATA WITH TAB SEPARATORS

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
 
A

Allen Browne

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

Guest

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

SUB

cheers allen,

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

cheers

SUB
 
Top