TransferText help

[travismp]

I am trying to set up a macro to export a txt file so I am using the TransferText command inside a macro. All is setup and working fine. My question is this:

Is there a way to change the default symbol used to separate the columns per record?

Right now the database will use a comma to separate data so the resultset looks like this when you open the text file

"STEVE","WALMART","BOOKS","345"

I would like it to replace the comma with a | (horizontal line) and then drop the quote signs so the output would look something like:

STEVE|WALMART|BOOKS|345

Can I change the default to drop the quotation marks and change the comma to a horizontal line? Thank you!


I can ever try to set this up in VB instead of a macro if needed.

 

[boblarson]

Travis, you can do this with an Export Specification. See here for how to build one and then use it:
http://www.btabdevelopment.com/main...teanExportSpecification/tabid/64/Default.aspx

 

[travismp]

I am running an Access 2000 DB. It looks as if that Wizzard is not an option for me?

 

[boblarson]

It is there in 2000. What you have to do to get there (and I'll have to try to add that to the screenshots later) is to select your table or query and then go to FILE > EXPORT and then you will get the dialog that comes up to export.

 

[travismp]

Gotcha... it is working PERFECT!!! Thank you again Bob. Once again you save the day. A modern day superhero of sorts you are.