[NeilPeart]

I am in IT and I've never done database work. I'm now responsible for importing an Access file to SQL. I cannot use the Oracle Migration software because I don’t have the privileges it requires. I am forced to use SQL*Plus Release 8.1.7 (connected to a Unix server running Oracle 9i Release 9.2.0.4). Please don’t lambaste me for working in IT and lacking exposure to db administrating; the situation simply did not arise until now. So far I have converted the Access file to a .csv and I don’t know what else to do. There is no one to help me with this issue and the project must be completed ASAP. Any input at all will be appreciated.

 

[mr_superlove]

Does the table already exist?

 

[NeilPeart]

Nothing exists yet.

 

[mr_superlove]

If you can wait 30 minutes I can help you out. I have to run to a meeting in the meantime!

 

[NeilPeart]

Any help you can offer will be appreciated (I am a patient man)!

 

[mr_superlove]

Here are a couple of things to look at in the meantime:

CREATE TABLE:
http://www.ss64.com/ora/table_c.html

INSERT INTO:
http://www.ss64.com/ora/insert.html

 

[mr_superlove]

Any chance I could talk to you via YahooIM right now?

Well, there are a couple of ways which you could go about this. One would be choosing "Export..." from Access and then choosing "ODBC Data Sources". Doing this bypasses the need to export as a csv file, but does require some prep work.

OR, you could write out the SQL commands and execute them, which will also require some prep.

The Access option is easier, but is kind of like using a calculator without ever learning your multiplication tables. If you'll be doing more DB work in the future, it might be best to go with the SQL.

 

[NeilPeart]

Many thanks and gratitude is extended to mr_superlove and gpalmer, who helped me create the DB. Now to get SQL to interface with our custom java application...

 

[gpalmer]

Quote:

Originally Posted by NeilPeart Now to get SQL to interface with our custom java application...

Can you say JDBC? Sure I knew you could!

 

[skullguise]

If this is a one-time load, or even a few times, just do it through MS Access, with a link to the Oracle Table via ODBC. Create an "Append Table" query and just add all Access table records to the linkd Oracle Table.

I used to do this each month for a credit card feed we wanted loaded into our Finance system.

If not a single or limited time load, then yes, integrating it into your java process with JDBC is probably best.

Good luck, hope it works/worked out OK