Re: how to get data from exel sheet with macros
MySQL cannot query data from Excel spreadsheets.
The common recommendation for transferring data from Excel to MySQL is to save the Excel document as a CSV file, and then load that CSV data into a MySQL table, using LOAD DATA. Then you can query the table in MySQL.
I think it is strange to keep frequently-updating data in an Excel spreadsheet. I would keep the data in MySQL instead.
Subject
Written By
Posted
Re: how to get data from exel sheet with macros
July 17, 2006 10:03AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.