export text record separator

[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

 

[Arvin Meyer [MVP]]

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)

 

[John Spencer]

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