Reading MS Access Table from Stored Procedure
789931Aug 6 2010 — edited Aug 6 2010How can I use an Oracle stored procedure to directly read data from a MS Access table?
Oracle is running on Unix and the MDB is a Windows file. I am trying to convert to Oracle a MS SQL Server stored procedure that uses a 'distrbuted query' technique that looks like the following example:
SELECT *
INTO #Reserve
FROM OPENROWSET(
'Microsoft.ACE.OLEDB.12.0'
,'Z:\Shared\ReserveTable.mdb'
;'admin'
;''
,'SELECT *
FROM [RESERVE