| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I merge multiple files using SQL?
Hi there,
I try to merge a few dozens of .csv files into one worksheet. This works well with a query like: SELECT * from file1 UNION SELECT * from file2 ... However, the querytable.command does not seem to accept more then 40 files (may be path-length dependent). Is there some other SQL method to merge files. I also tried the "SELECT INTO" command but that only resulted errors. Any ideas? Best Regards, Marc |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I merge multiple csv files in one Excel file? | Excel Worksheet Functions | |||
| merge multiple worksheets from multiple excel files into oneworksheet | Excel Discussion (Misc queries) | |||
| How do I merge multiple xls files into one file? | Excel Discussion (Misc queries) | |||
| How do I merge multiple xls files into one file? | Excel Discussion (Misc queries) | |||
| How can I merge multiple sheets from different Excel files workbo. | Excel Worksheet Functions | |||
Threaded Mode
