I have a MsAccess app that is/was being used to populate a spreadsheet everyday. Since the Jet was updated it no longer works. From an order form I create a temporary table and use that to push to the excel file.
Using the following sql
INSERT INTO Sheet1 ( F1, Vendor, Item, [$ each], [# each], Cost )
SELECT TempTable.DateOrd, TempTable.MFG, TempTable.ITEM, TempTable.[$EA], TempTable.qty, TempTable.[Tot$]
FROM TempTable, Sheet1;
Not sure how to fix the error. Any help is appreciated.
Using the following sql
INSERT INTO Sheet1 ( F1, Vendor, Item, [$ each], [# each], Cost )
SELECT TempTable.DateOrd, TempTable.MFG, TempTable.ITEM, TempTable.[$EA], TempTable.qty, TempTable.[Tot$]
FROM TempTable, Sheet1;
Not sure how to fix the error. Any help is appreciated.