Trying to import excel file into access linked tables to oracle???

[notageek7]

Does anybody know if there is a way to import data from an excel file into a table that is linked to an oracle db. My code imported the file into an access db previously and now the table to import into is a linked table to an oracle db. So the problem is that oracle dosn't have autonumbers so when adding records I use code that retrieves the next sequence for the table. So, how can I import records and access the oracle sequence as well????


previous line of code that worked:
DoCmd.TransferSpreadsheet acImport, , curSheet.Name, wbName, True

 

[PHV]

Import the data into a temporary access table, populate the oracle table with an append query and then get rid of the temporary table.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244