Transfer data from excel/acess to a MySQL database

[SuperTom]

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

[wdillsmith]

Export it into csv or tab delimited format. You can import into mysql with

LOAD DATA INFILE 'path/file.txt' INTO TABLE your_table;

[Gtal]

Yes indeed it is the easiest way to do it.

But is it just a one shot project?

[kgun]

Originally Posted by SuperTom

Hi all,
I don't have a lot of technical background and I would like the operation to be as simple as possible. Any ideas?

Added to the above:

1. Note access files can be easily imported into an Exel spreadsheet.
2. In Exel you save the file as a plain text (.txt) file.

MySQL tools

1. MySQL :: MySQL Administrator
2. phpMyAdmin | MySQL Database Administration Tool | www.phpmyadmin.net

[SuperTom]

Thanks for your answers.

Originally Posted by Gtal

Yes indeed it is the easiest way to do it.

But is it just a one shot project?

No. Indeed, I would like to repeat the transfer three times a week.

[Gtal]

Then you should have a look at etl tools.

Those are able to automate a task (like, for instance, the transfer you are decribing) by bulding a script that will execute itself on a user-defined basis.

[SuperTom]

I am downloading Talend Open Studio and I'll try it.

So you mean that the program is able to build a script and I won't have to write code myself ?

And what's more I can automate the task... It's perfect then

[Gtal]

Yes, depending on the operation you want to perform, you have no or almost no code to write yourself.

What's more, if you have questions don't hesitate to ask and don't forget to consult the User guide and Reference guide which are quite comprehensive.

[SuperTom]

Thanks again !

I managed to do what I wanted, and even more, I may have some questions related to Talend Open Studio, but I guess I will open another thread, since it is a different topic.

[Gtal]

Ok don't hesitate if you have other questions related to other projects which imply using Talend Open Studio.

[xsaviorx1]

thanks for the information!!!! it is really very useful!!!!

[Gtal]

Thanks Xsaviorx. If you'd like more information, FAQ 's and tutorials about Talend, I would suggest you look at Talendforge. The site, Talendforge, will be able to help you.