export to text file problem

A

Arnaud Lesauvage

Hi all!

I have a problem when exporting my access 2000 tables to txt files
(including field names, separated by ";") :
Access always adds a blank line at the end of the text file. It is just a
CR/LF after the last record, but it is enough to spoil an import into mySQL
afterwards.
Does anyone know of a workaround for this?
I am not very willing to use VB to do this, since the exported files are
quite big (more than 40MB for some of them). File handling in VB does not
allow easy manipulation, and I would have to parse the entire file without
the last 2 chars just to get rid of this line...

Any suggestion?

Thanks a lot for any help!

Arnaud
 
A

Arnaud Lesauvage

Depends on how you are exporting it.

In a Macro using TransferText (delimited) with field names.

Regards,
Arnaud Lesauvage
 

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 'csv' using Access2007 2
Problem with CR LF and Text Box (Access) 0
export text record separator 2
import out look contacts csv 4
Exporting and Zipping Files with Access VBA 4
Exporting a custom delimited file from an .adp 0
Exporting Fixed Width Text File 4
Parse and view data in memo field 4

Top