Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel ADO-Bad Field in Access
I'm using ADO within Excel to update an Access table and query off it.
The field Zone either has a value of 0 (zero) or P. However, when I try to include this field in a query or in the where clause of my SQL statement, I get the error message: "Method Open of Object Recordset failed" I've tried making the value text by using the excel text function and then uploading the value but this hasn't worked. Would appreciate any feedback. Thanks in advance. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel ADO-Bad Field in Access
Al,
Can you post your SQL query or offending code, and perhaps the table definition. Robin Hammond www.enhanceddatasystems.com "Al" wrote in message ... I'm using ADO within Excel to update an Access table and query off it. The field Zone either has a value of 0 (zero) or P. However, when I try to include this field in a query or in the where clause of my SQL statement, I get the error message: "Method Open of Object Recordset failed" I've tried making the value text by using the excel text function and then uploading the value but this hasn't worked. Would appreciate any feedback. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Export Access to Excel text field with numbers | Excel Discussion (Misc queries) | |||
Access to Excel memo-type field transfer | Excel Discussion (Misc queries) | |||
Export memo field in Access to Excel - data gets cut off | Excel Discussion (Misc queries) | |||
import date field from access into excel | Excel Programming | |||
import date field from access into excel | Excel Programming |