Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically join files
I would like to set up Excel to automatically join 3 .csv files (located in the same folder), each month, and place the result set in a spreadsheet. Is this possible? Thanks for your help.
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically join files
On Monday, October 22, 2012 11:06:07 AM UTC-5, wrote:
I would like to set up Excel to automatically join 3 .csv files (located in the same folder), each month, and place the result set in a spreadsheet. Is this possible? Thanks for your help. Yes. but you need to provide much more info and files. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically join files
On Monday, October 22, 2012 11:26:17 AM UTC-6, Don Guillett wrote:
On Monday, October 22, 2012 11:06:07 AM UTC-5, wrote: I would like to set up Excel to automatically join 3 .csv files (located in the same folder), each month, and place the result set in a spreadsheet. Is this possible? Thanks for your help. Yes. but you need to provide much more info and files. Thanks for responding, Don. I guess my question is really whether from VBA I can open multiple connections to the csv files and then execute a SQL string to do inner joins on those files. Hope I'm being more clear. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Automatically join files
On Monday, October 22, 2012 10:06:07 AM UTC-6, wrote:
I would like to set up Excel to automatically join 3 .csv files (located in the same folder), each month, and place the result set in a spreadsheet. Is this possible? Thanks for your help. I just needed to create a DSN Control PanelData Sources, then turn on macro recorder, go to MS Query do the SQL, turn off recorder and examine the code. It's all I need. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
join imported Excel 2007 files | Excel Worksheet Functions | |||
Join tables like inner join in Access | Excel Discussion (Misc queries) | |||
how do I join multiple excel files into 1 file? | Excel Discussion (Misc queries) | |||
To join some sheets of several files in one file | Excel Programming |