TransferText Comma Delimitted File

[Moxioron]

Hello all.

I have some VBA that transfers a query to a text file.

DoCmd.TransferText acExportDelim, , "qry_VISA Statement Final Index", "R:\DEPT-BR\CONSUMER LENDING\VISA\VISA Statements\VISA Statement Final Index.txt", False

Two issues:

1.) I have two expressions in my query that don't transfer (they show up on the query when I run it)
2.) I don't want the quotes around each field

Thoughts, feedback, suggestions? Thank you.

 

[Joe4]

1.) I have two expressions in my query that don't transfer (they show up on the query when I run it)

What are some examples of these values for these that show up in your query but not in the exported files?
What gets exported in its place (just a blank betweem commas)?

2.) I don't want the quotes around each field

Create an Export Specification and use that in your export (it is the first argument after "acExportDelim").
All you need to do to accomplish this is go through the process of exporting the file manually using the Export Wizard, and just before you click Finish, click on the button that says "Advanced", and change the value in the Text Qualifier option from a double quote (") to {none}. Then click Save As and give your export specification a name.

Then just add that to your code.

DoCmd.TransferText acExportDelim, YourExportSpecificationNameHere, "qry_VISA Statement Final Index", "R:\DEPT-BR\CONSUMER LENDING\VISA\VISA Statements\VISA Statement Final Index.txt", False

 

[Moxioron]

Thanks so much for the response.

I have two expressions that prompt the user to type a value. They show up in the query just fine and when I copy and paste into Excel they are there. However, they are just empty spaces on an export.

I tried your suggestion about saving the export,but during the export if I don't select 'Export Data with formatting and layout' I get a 'Too few parameters. Expected 1' message.

 

[Joe4]

Which version of Access are you using?

 

[Moxioron]

2010

 

[Joe4]

Can you post the SQL code of the query you are trying export?