export to text file problem

  • Thread starter Thread starter Arnaud Lesauvage
  • Start date Start date
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
 
Depends on how you are exporting it.

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

Regards,
Arnaud Lesauvage
 
Back
Top