export text record separator

  • Thread starter Thread starter Toxalot
  • Start date Start date
T

Toxalot

What is used as the record separator or line ending when exporting
text from Access? Is it possible to change this? I'm trying to prepare
a text file for import into MySQL and the import function wants
char(30) as a record separator.

Jennifer
 
I think that Char(30) means a fixed length field of 30 characters. To do
that either build a query, or write to file. Something like:

FieldName & Space(30 - Len(FieldName)
 
Chr(30) is the code for record separator.

Char(30) is the way to declare a field as a fixed-length text field of 30
characters in MS SQL and possibly in MySQL (I don't work with MySQL).

Normally Access will use Chr(13) & Chr(10) to indicate a new record line.

If you want to export to a text file with some other delimiter, you are going
to have to develop a routine to do this yourself.

Take a look at the VBA Print and Write statements.



John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 
Back
Top