From Excel and Access into a MySQL database
Fri, 11/21/2008 - 13:44 — Ichicatos
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!
I am no expert, but these files can be sved as CSV and CSV is pretty well transferable between databases I should think. If this is ok then look at this list in SnapFiles
http://www.snapfiles.com/downloadfind.php?action=s&search.x=29&search.y=...
Tony
Hello Ichicatos,
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. You can download it at http://www.talend.com/solutions-data-integration/data-migration.php
Post new comment