|  | export text record separator | | |
| | | Toxalot |  |
|  Posted: Mon Sep 22, 2008 12:07 pm Post subject: export text record separator |  |
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] | |
| | Posted: Mon Sep 22, 2008 12:07 pm Post subject: Re: export text record separator | |
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)
--
Arvin Meyer, MCP, MVP
LINK
LINK
LINK
"Toxalot" <toxalot@gmail.com> wrote in message
news:88929427-5674-452e-b4ac-2852a271342e@m45g2000hsb.googlegroups.com...
| Quote: | 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 |
|
| |
| | | John Spencer | |
| | Posted: Mon Sep 22, 2008 12:07 pm Post subject: Re: export text record separator | |
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
Toxalot wrote:
| Quote: | 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 |
|
| |
|
|
