Import CSV then Export TXT (Tab Delimited)

P

Paul

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
 
P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top