The CSV engine requires that every field be surrounded by double quotes.
If your text has double quotes, escape them or change them.
If you don't have that kind of time...
You may want to do this the weird way using Microsoft Access.
1. Install MyODBC (Takes like 30 seconds or less)
2. Create ODBC connection using this path
a. Control Panel
b. Administrative Tools
c. Data Sources (ODBC)
3. Create Access Database.
4. In the Access Database, create Database Link to the MySQL table.
5. In the Access Database, create Database Link to your Spreadsheet.
6. Construct 'Append Query' to copy data from the XLS to the MySQL table
Have fun !!!
-----Original Message-----
From: Hiep Nguyen [mailto:[EMAIL PROTECTED]
Sent: Monday, January 14, 2008 10:52 AM
To: mysql@lists.mysql.com
Subject: import from exel into mysql
hi everyone,
i have a large ms excel data (text) file that i need to import to my table
in mysql. does any one have a suggestion how to do this? i'm try to
export to csv file, then import to my table, but i have so much problems
with delimeters
thanks
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
