access data -> txt file -> mysql

i have a database in ms access with fields including number, money, and text. i want this to be on mysql.

i have tried using the export function to get it into a tab deliminated txt file and then inserting data, but text fields comeout having quotes around them, and some fields have a 0 instead of the number.

how can i convert my table data from access to a txt file and make it look the same on the mysql server?

Hi David,

How r u doing?,

I don't have any idea about upsizing ms-access to Mysql(In Sqlserver we'll get upsizing wizard.Here also some tools must be their.Try to get some information from mysql support).

But for txt to mysql you can use Load data statement insted of mysqlimport.

LOAD DATA INFILE "C:mydiremp.txt" INTO TABLE emp;


full syntax for LOAD Data:

LOAD DATA INFILE 'emp.txt' INTO TABLE tbl_name FIELDS TERMINATED BY 't' ENCLOSED BY '"'LINES TERMINATED BY 'n';


You can escape from '"' using;
ESCAPED BY '"'


Hope you may get some hint from this...





[This message has been edited by Shiju Rajan (edited March 27, 2000).]

Hi Shiju

im doing pretty good, im having tons of fun working with perl and mysql (much thanks to you and DEVSHED).

I was able to resolve my problem with the decimal points. It appears that he file that ms access creates adds a $ to the decimal values, after i remove this $ then it works fine.

Thanks for your help

as a ridiculous aside - sad git that I am I have in the past (in frustration) exported MSaccess data into MSExcel and then exported that as a comma seperated file !!!! yes I am lazy (but it worked).

------------------
Simon Wheeler
FirePages -DHTML/PHP/MySQL

ehhee i kind of was lazy too. i got the file exported to a txt file and then used word to search/replace all the $ signs and then imported into the mysql table