Thanks With my statement SELECT * FROM OPENDATASOURCE ('Microsoft.jet.OLEDB.4.0', 'Data Source=h:\Shopinfo\shopdetail.mdb')...ShopDetail WHERE SHOP_PFCNTR = $Shop Number$
The error I get is the following ARERR [552] Failure during SQL operation to the database : ORA-00933: SQL command not properly ended The MDB does not have a passowrd. I think I'm missing a quote somewhere. A question I had is, do I need to setup a System Data source on the server to this Microsoft access db or can that be done on the client? "Ashton, Jim (JUS)" <jim.ash...@ontario.ca> Sent by: "Action Request System discussion list(ARSList)" <arslist@ARSLIST.ORG> 04/17/2009 10:34 AM Please respond to arslist@ARSLIST.ORG To arslist@ARSLIST.ORG cc Subject Re: SQL statement ** The following works for SQL Server in a similar situation. Not sure what the corollary to "OPENDATASOURCE" is for Oracle. SELECT X.* FROM OPENDATASOURCE('Microsoft.jet.OLEDB.4.0', 'Data Source=\\usranfb\transfer\Shopinfo\shopdetail.mdb; Jet OLEDB:Database Password=<password>;')...<table name> X WHERE SHOP_PFCNTR = $Shop number$ <password> is an optional database level password - if there is no database password on the .mdb file I think you can omit the entire "Jet OLEDB:Database Password=<password>;" phrase. <table name> is the name of the table containing the SHOP_PFCNTR field in your Access database. Hope this helps, Jim. _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers Are"_ ************************************************************* This e-mail message, including any attachments, is for the sole use of the addressee(s) to whom it has been sent, and may contain information that is confidential or legally protected. If you are not the intended recipient or have received this message in error, you are not authorized to copy, distribute, or otherwise use this message or its attachments. Please notify the sender immediately by return e-mail and permanently delete this message and any attachments. Dunkin' Brands Inc. makes no warranty that this e-mail is error or virus free.