F
frank
have created a sql append statment to gather info from excel spreadsheet.
The problem i seem to be having is adding more then one "FROM" Statment. the
code looks like this:
INSERT INTO PP1SUB ( F1] )
SELECT [Second by second$BW2:BW1881].F1.
FROM [Excel 8.0;HDR=No;database=G:\R&D\Vehicle testing
Data\summary.xls].[Second by second$BW2:BW1881];
What i would like to do is add another feild from the same workbook. What i
have tried is this:
INSERT INTO PP1SUB ( [F1],[F2] )
SELECT [Second by second$BW2:BW1881].F1,[Second by second$B2:B1881].F2
FROM [Excel 8.0;HDR=No;database=G:\R&D\Vehicle testing
Data\summary.xls].[Second by second$BW2:BW1881].[Second by second$BW2:BW1881];
When i run this. Access says it is unable to find the second field. Once
this issue has been resolved. I am guessing i could just change the statment
to make table.
The problem i seem to be having is adding more then one "FROM" Statment. the
code looks like this:
INSERT INTO PP1SUB ( F1] )
SELECT [Second by second$BW2:BW1881].F1.
FROM [Excel 8.0;HDR=No;database=G:\R&D\Vehicle testing
Data\summary.xls].[Second by second$BW2:BW1881];
What i would like to do is add another feild from the same workbook. What i
have tried is this:
INSERT INTO PP1SUB ( [F1],[F2] )
SELECT [Second by second$BW2:BW1881].F1,[Second by second$B2:B1881].F2
FROM [Excel 8.0;HDR=No;database=G:\R&D\Vehicle testing
Data\summary.xls].[Second by second$BW2:BW1881].[Second by second$BW2:BW1881];
When i run this. Access says it is unable to find the second field. Once
this issue has been resolved. I am guessing i could just change the statment
to make table.