Transfer data from Excel and Access into a MySQL database

[trusty]

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!

[Talgru]

Hi, trusty.
You might want to have a look at some ETL tools available on the net. They do exactly what you describe (and much more).
But I'll ask this: are you ready to spend lots of money on expensive software? If not, and since it seems to be a one-shot project, I'd recommend using open source ETL tools, freely downloadable 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.

[trusty]

As you said I've had a look at several ETL Tools you were mentioning and it seems to be what I need. I'll give Talend a try and let you know. Thanks for the help!