Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

need an updatable query error

Status
Not open for further replies.

osurfc

Technical User
Mar 28, 2006
20
US
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.
 
Hi Duane,

Just saw this and am wondering about the specific meaning of "Access can no longer update Excel files.". I have several Access mods that document Access queries, tables, etc into an Excel sheet. It specifically says "

wbExcel.Sheets(1).Range("A" & lngRow) = db.QueryDefs(lngQuery).Name
wbExcel.Sheets(1).Range("D" & lngRow) = db.QueryDefs(lngQuery).SQL

Can I no longer do this? Which version of Access or Excel cut it off?

Thx

Kevin
 
Kevin, you still can use automation to update excel files, but not SQL code.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886
 
Hi again PHV. Thanks for prior help.

I also have Excel code that simple tells Excel to read a recordset (that is created by Access or Excel and presumably others) that I hand it.

Is that still working??

Thx

Kevin
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top