S
S Davis
I need to pull data from a daily generated excel file, with a changing
file name. The file will always be in the same location.
I ran the connection info on the excel file I would like to hit (tip --
or tips on gathering the connection information and SQL from a broken
query) and it came back with this:
ODBC;DSN=Excel Files;DBQ=C:\ExcelFiles\ExcelFile - Mar. 2,
07.xls;DefaultDir=C:\ExcelFiles
\;DriverId=790;MaxBufferSize=2048;PageTimeout=5;
What I want to do is refresh a query with a piece of VBA so that it
will always pull in the ExcelFile of the current date [ie "Excelfile -
" & format(date, "Mmm. dd, yy") & ".xls" ]
Can anyone help with that?
file name. The file will always be in the same location.
I ran the connection info on the excel file I would like to hit (tip --
http://groups.google.ca/group/comp....browse_thread/thread/20200ae298c993a4/?hl=en#see this useful thread here:
or tips on gathering the connection information and SQL from a broken
query) and it came back with this:
ODBC;DSN=Excel Files;DBQ=C:\ExcelFiles\ExcelFile - Mar. 2,
07.xls;DefaultDir=C:\ExcelFiles
\;DriverId=790;MaxBufferSize=2048;PageTimeout=5;
What I want to do is refresh a query with a piece of VBA so that it
will always pull in the ExcelFile of the current date [ie "Excelfile -
" & format(date, "Mmm. dd, yy") & ".xls" ]
Can anyone help with that?