Won Lee wrote: > Perhaps... > > I may be missing something here. > Because I have about 15 seperate Access DBs on my workstation and don't want > to create 15 system ODBC connections for once in a life import, I thought > doing it via a text file would be easier. > > Unless you are talking about something else.
No. Because you have memo fields in Access with funny characters (new-lines), this may be your easiest option. You only have to create one DSN. Make it to a temporary database that has your new tables in it. Export the data with the select * into.... Then if you want to move the data to a different db you can move either the .MYI, .MYD, and .frm to the right place OR you can use mysqldump. b. > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bill Adams > Sent: Wednesday, November 14, 2001 5:31 PM > To: Won Lee > Cc: mysqlList > Subject: Re: Text qualifiers > > Won Lee wrote: > > > I have an slew of Access DBs that I need to port some of the info into a > > MySQL DB. > > I guess my main problem is my I have no idea in what format to export my > > data from the Access DB. > > In general I export it as a tab delimited file with no text qualifiers. > > Unfortunately, much of the data has a carriage return as part of the data. > > The carriage returns terminate the line and my import fails. > > > > I tried to wrap the text in double quotes to tell it not to terminate the > > line. However, my imports have still failed. This could be due to my > lack > > of experience or wrong syntax. But I did everything as told in the > > documntations. > > Not really an answer to your question but you can also "select * into table" > from access. > > b. > mysql -- Bill Adams TriQuint Semiconductor --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php