Oracle 8 has just been installed and I'm not real familiar w/it. I do know a little SQL, but really haven't worked w/ it too much to feel confident. I have about 3600 records in a flat table in Access97 with columns for 'address', 'po box','cost center','office name', 'zip code', 'city' 'county', and I want to get it all into a one table of about 160 tables in Oracle8. How can I use either SQL or an Oracle8 GUI feature to do this?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
IMPORT DATA FROM ACCESS97 INTO ORACLE8
- Thread starter dummie2
- Start date
I think this probably belongs in the Programmers DBMS Oracle8 forum.<br><br>Just guessing, but there should be ODBC drivers to allow access to the Access97 data from Oracle8. <p>Ged Jones<br><a href=mailto:gedejones@hotmail.com>gedejones@hotmail.com</a><br><a href= > </a><br>
- Status
Similar threads
- Locked
- Question
- Locked
- Question