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.

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.

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.

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.