Oracle 9i - importing data to access

[Tulip2]

Hi, I am new to Oracle. We have Oracle 9i and I was wondering if anyone knows where I can get info on importing data to an access database. I also need to download some of the data to excel. thanks Tulip

 

[stefanhei]

Hi.
If you just want to do a one time load into Excel, you could spool your data via SQL*Plus in CSV-format and then simply open the output file in Excel. The settings for a CSV-output could look like this:

set feedback off
set flush off
set heading off
set headsep off
set pagesize 0
set newpage none
set recsep off
set termout off
set trimspool off
set verify off
set wrap off
set colsep ';'
spool yourFile.csv

Stefan

 

[Turkbear]

You can insert or link Oracle tables to Access thru the 'Get External Data' option of the File menu..

For Excel, you can use their 'Get External Data' to populate your spreadsheet.

Both will need an ODBC DSN for your Oracle database that works..Can Be Microsoft's - it seems to work better than Oracle's sometimes but with v9 of Oracle I am not sure...

 

[Tulip2]

Thank you both - at least I have a place to start. I am not sure which way will work best. I have classified data that has to be loaded to a classified laptop, the user can print the data using excel, and then I have to upload any changes back to the original database, this is where it is becoming tricky. So, I thought if I loaded it to access that might be the easiest, let them run excel and update the access database, and load any data changes back to oracle. Any other ideas?