From Excel and Access to a MySQL database

Question

Post reply

From Excel and Access to a MySQL database

tom.ruster

Newbie

Points: 9
More actions
October 6, 2008 at 8:46 am

#194087

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!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Glen SSCertifiable Points: 6737 More actions · Answer 1

H-m-m... And what MySQL has to do with SQL Server dedicated forum?

tbeadle SSCommitted Points: 1635 More actions · Answer 2

Hello,

Both Excel and Access can export data in a comma delimited format. Also known as a .csv file. They can also export data in a plain text file in a fixed length format.

MySql has facilities to import such data files and or you can use a programming language to aid in this endevor.

MySql is also ODBC compliant, which means it can communicate with other odbc compliant entities.

I don't know how technically skilled you are but this site is involved with Microsoft SQL server and it's uses vis v vis TSQL ( data base language ).

I would suggest you do a google search on MySQL and there were be a plethora of sites that will have some methods, tools and probably good guideance.

Good Luck, and if you need more info, don't be afraid to ask.

Regards,

Terry

Tguru Valued Member Points: 52 More actions · Answer 3

Hi,

What i'd recommend first is that you search on the net. Might be easier than here.

Considering your question, you might want to have a look at some ETL tools available on the net. They do what you describe (and much more).

And 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

Visit Talend[/URL] and Talendforge[/URL] for open source ETL and data integration.

tom.ruster Newbie Points: 9 More actions · Answer 4

As you said tguru 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!