I want export a Access file to MySQL,then I do as follow:
first:
A Access file export to a Txt file
Create a database in MySQL for export
second:
at MySQL DOS command prompt,
I use "load data infile txtfile into table table fields terminated by ',' enclosed by '"' lines terminated by '\n';
but only some of total records be exported.
if I use "load data infile txtfile into table table fields terminated by ',' lines terminated by '\n';
then it works successfully.
why?
sorry, my poor english.
