Import CSV then Export TXT (Tab Delimited)

[Guest]

Is there a way to do this, using the functions available in macros.

Reason being that the process needs to be used by end-users, and requires to
be automated. It is important that the export file is in tab delimited format.

The transfertext function is not giving me the output in tab(delimited)
format and should the CSV file be imported as fixedwidth or delimited, for
Access to then convert to txt (tab delimited)

Thanks
Paul

 

[pietlinden]

Is there a way to do this, using the functions available in macros.

Reason being that the process needs to be used by end-users, and requires to
be automated. It is important that the export file is in tab delimited format.

The transfertext function is not giving me the output in tab(delimited)
format and should the CSV file be imported as fixedwidth or delimited, for
Access to then convert to txt (tab delimited)

Thanks
Paul

it's a cinch with about 5 lines of code. Never use macros, so I'm not
sure how useful they are. I would check out Albert Kallal's code for
Super Easy Word Merge. he has code there that basically creates a tab-
delimited file, (I think). If not, you'd just replace the ", " stuff
with vbTab and you're good to go. You can find his site off of the
Access Web site. www.mvps.org/access