Prepare for your Next Interview
|
Welcome to the Geeks Talk forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
Data Transfer: from Access and Excel to MySQL database
This is a discussion on Data Transfer: from Access and Excel to MySQL database within the Data Warehousing forums, part of the Databases category; 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 ...
|
|||||||
10-06-2008
|
|||
|
|||
|
Data Transfer: from Access and Excel to MySQL database
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! 
|
| Sponsored Links |
|
10-07-2008
|
|||
|
|||
|
Re: Data Transfer: from Access and Excel to MySQL database
Hi, tomrust.
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 Talend - Open Source Data Migration
|
|
10-09-2008
|
|||
|
|||
|
Re: Data Transfer: from Access and Excel to MySQL database
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!
|
|
08-08-2009
|
|||
|
|||
|
Re: Data Transfer: from Access and Excel to MySQL database
advantages of migrating ms access databare to sql server
|
|
08-10-2009
|
|||
|
|||
|
Re: Data Transfer: from Access and Excel to MySQL database
For moving data from excel to sql,another way is by simply exporting data from excel file to the sql table by using sql data transfer wizard.
|
 |
|
«
ETL Aggregator transformation
|
The informatica service on local computer started and then stopped
»
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| upload excel sheet data to an oracle database table | soundari | Data Warehousing | 1 | 10-09-2008 12:10 PM |
| Data Warehouse Bulk Data Transfer | Lokesh M | Data Warehousing | 0 | 01-31-2008 06:52 AM |
| I need to get data from database and store in Excel | shyam_meghansh | QTP | 3 | 08-06-2007 10:18 PM |
| Control file syntax to transfer data from multiple data files | Geek_Guest | Oracle Apps | 0 | 06-14-2007 11:35 AM |
| How do you connect/configure qtp to access data from database? | Geek_Guest | QTP | 2 | 05-02-2007 03:31 PM |
All times are GMT -4. The time now is 02:39 PM.
