Transfer data from Excel and Access into MySQ Closed

Question

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!

vijay · Accepted Answer

I am developing a apllication in php where i need some reports to be generated in excel sheets and pdf for that i have to get data from mysql and add that to excel sheet

Im-ur-neighbor · Answer

You might want to have a look at some ETL tools available on the net. They do exactly what you describe.  But are you ready to spend lots of money on software? If not, and since it seems to be a one-shot project, I'd recommend using open source ETL tools, downloadable for free 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 look at it at: https://www.talend.com/

Transfer data from Excel and Access into MySQ

2 responses

Similar discussions

Subscribe To Our Newsletter!