Here is the connection and command text data for a simple Excel query table:
Connection
ODBC;DSN=Excel Files;DBQ=C:\HDQRY_Data.xls;DefaultDir=C:\;DriverId=790;FIL=excel 8.0;MaxBufferSize=2048;PageTimeout=5;
Command Text
SELECT `Data$`.Name, `Data$`.DOB
FROM `C:\HDQRY_Data`.`Data$` `Data$`
How do I convert this select query into an append (INSERT INTO) query such that the data in HDQRY_Data.xls will be appended to another Excel spreadsheet: C:\Test.xls?
Connection
ODBC;DSN=Excel Files;DBQ=C:\HDQRY_Data.xls;DefaultDir=C:\;DriverId=790;FIL=excel 8.0;MaxBufferSize=2048;PageTimeout=5;
Command Text
SELECT `Data$`.Name, `Data$`.DOB
FROM `C:\HDQRY_Data`.`Data$` `Data$`
How do I convert this select query into an append (INSERT INTO) query such that the data in HDQRY_Data.xls will be appended to another Excel spreadsheet: C:\Test.xls?