Transfer data from Excel and Access into MySQ

Trscut - Oct 8, 2008 at 05:12 AM
 Im-ur-neighbor - Apr 3, 2009 at 08:10 AM
Hi all,

I need to transfer data (client name, address etc) from excel and access into a MySQL database.
I don't have a lot of technical background and I would like the operation to be as simple as possible.

Any ideas? Thanks!

2 replies

I am developing a apllication in php where i need some reports to be generated in excel sheets and pdf for that i have to get data from mysql and add that to excel sheet
Apr 3, 2009 at 08:10 AM
You might want to have a look at some ETL tools available on the net. They do exactly what you describe. But are you ready to spend lots of money on software? If not, and since it seems to be a one-shot project, I'd recommend using open source ETL tools, downloadable for free compared to other licensed tools. You can have a look at Talend Open Studio, it's pretty easy even if you don't have much technical background. You can look at it at: