MySQL Forums
Forum List  »  Microsoft Access

Re: Import Access Tables
Posted by: Devart Team
Date: December 21, 2009 02:16AM

>I am now trying to load a csv file into my MySQL table and I am getting errors and I cant figure out why…

To load data, try this query -

LOAD DATA LOCAL INFILE 'F:/TEMP/incident_case.csv' INTO TABLE coordinates_database.incident_case
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n';

Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/

Options: ReplyQuote


Subject
Views
Written By
Posted
16006
December 18, 2009 01:42PM
9603
December 18, 2009 03:58PM
6157
December 21, 2009 02:10AM
Re: Import Access Tables
4525
December 21, 2009 02:16AM
3822
December 21, 2009 08:46AM
3795
December 21, 2009 09:51AM
4856
January 04, 2010 07:56AM
3633
January 20, 2010 02:16PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.