You are reading a single comment by @dubtap and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@dubtap
^I do something like that to have single pivot table referencing multiple source spreadsheets so people can edit just their data and not have access to anybody elses and I can merge the results.
Connection String
DBQ=I:\File1.xlsb;Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DriverId=1046;MaxBufferSize=2048;PageTimeout=5;
Command Text
SELECT * FROM [Sheet1$] UNION ALL SELECT * FROM
I:\file2.xlsb.[Sheet1$] UNION ALL SELECT * FROMI:\file3.xlsb.[Sheet1$] UNION ALL SELECT * FROMI:\file4.xlsb.[Sheet1$]