Hello ;
Access 2000/ms sql server

I built a PassThroughQuery. It is an append to a sql server table. The
message I get is ODBC call failed. Invalid Object Named export_specs;

here is the sql:

INSERT INTO dbo.CUST_ORDER_BINARY ( CUST_ORDER_ID, BITS, TYPE,
BITS_LENGTH )
SELECT ID, ORDER_SPECS, TYPE, BIT_LENGTH
FROM Export_Specs;


Any body have any ideas on how to resolve this? BTW export_specs is an
actual table, it is an access table.

Thanks

Tony

Tony_E wrote:
execution. This means that it can only reference objects on that remote
database. Your sql server has no knowledge of anything contained in your
Access local database. Your options include:
1. Create a link in Access to the sql server table and use a non-passthrough
query to perform the insert.
2. Create a linked server in the sql server that points at your Access
database, and use OPENQUERY in your passthrough sql statement to retrieve
the results from Access.
3. Depending on the version of sql server, create either a dts or ssis
package to perform the data transfer
4. Use the VBA TransferDatabase method to transfer the data