Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Best way to export from Excel to MySQL?
I have over a thousand individual Excel files which contain data that I
would like to import into a MySQL database. Can anyone recommend an efficient way I can achieve this? I know that I can individually save each Excel file as a .csv file and import that into MySQL but this is going to take me too long with the number of files involved. What is the quickest way to "batch convert" multiple .xls files to .csv? Ideally I would be able to convert multiple .xls files to a single .csv file. Is there a command line that I could run, something along the lines of: c:\spreadsheetsexcel save *.xls *.csv or c:\spreadsheetsexcel save *.xls consolidated.csv Any help and advice gratefully received Len |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import MySQL data to Excel | Excel Discussion (Misc queries) | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
Export to Microsoft Excel from IE | Excel Discussion (Misc queries) | |||
excel chart export error runtime 1004 | Charts and Charting in Excel | |||
How do I get data (tables) from IE to export to an EXCEL sreadshee | Excel Discussion (Misc queries) |