Related:
- Transfer data from Excel and Access into MySQ
- How to transfer data in excel from one sheet to another - Guide
- How to transfer data from one excel workbook to another automatically using macro - Guide
- Transfer data from one excel worksheet to another automatically ✓ - Forum - Excel
- Excel - Selectively Transfer Data to Pre-defined Range - How-To - Excel
- How to automatically transfer data between sheets in Excel - Guide
2 replies
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
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/
