[matiucarr]

The line in the code where you "explode" each line from your dump of the table(s) in access uses ";". For CSV use ",".

$cols = explode(',', (str_replace("'", "''", $line)));

This will now convert 's (single quotes) appropriately for use in SQL expressions and then splits each input line along the ,s (commas) giving an array containing the items associated with each record.

[FiRe]

if the code isnt too long i'll manually do it for free, PM me...

[NeverMind]

Dr.Jamescook, could you post one line of the CSV file?
the seperator is causing the problem..

as for escaping the single quotes, you don't need to do that manualy! simply use addslashes() on the values and when you retraive them from mysql use stripslashes()..

I forgot who gave this to me, but whoever you are...thankyou. It saves me alot of time!

that would be me, I guess
http://www.programmingtalk.com/showthread.php?t=15964

you will also find that I replied to you about addslashes().. it could've saved you some good time

[Dr.Jamescook]

I intende on telling you guys last night but I got it done. I downloaded a fully functional free trial of navicat. This program did it but not without trouble. It would not do the Access file but it converted the Excel file with good success. Thanks a bunch for your help.

Here is one line of the csv file.
1,OT,1,Genesis,1,1,1,In the beginning God created the heaven and the earth.,

There you have it. I would like to still see if it is possible without buying a program (or free trials), so please continue this conversation. I'll be here and I'll help.

[moronovich]

you can also use access2mysql to automatically convert access db to mysql. (just google if you're interested)