Export to CSV question

O

ozlink

I have a database where I need to export a table to a CSV file.
This is the easy bit :)

The problem I have is the program that is going to import the CSV file
requires at the end of each record the following <F9><ESC><F9> as an
unquoted value

Currently a line from my CSV file looks as follows

"LIOAUS","","140104","I1170","LIOAUS","1","ea","11.6"

I have tried creating a new field in the export table with a default
value of <F9><ESC><F9> however when I export this I get

"LIOAUS","","140104","I1170","LIOAUS","1","ea","11.6","<F9><ESC><F9>"

This is fine apart from the quotes surrounding the <F9><ESC><F9>. The
program where it is going to doesnt like the quotes.
So I need the export to look like

"LIOAUS","","140104","I1170","LIOAUS","1","ea","11.6",<F9><ESC><F9>

Any Ideas

Thanks in Advance

Dave Macphail
 

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

Similar Threads

Export to CSV problem 1
Export to csv 6
Sendkeys to external application not working 1
date format problems with export to csv 1
Export part of table to .csv 1
Access Export to CSV 3
Export Access Query to a pipe delimited .csv file 5
TransferText using wrong format 0

Top