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!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Loading ORACLE Data in MSDE via VBA (ADO)

Status
Not open for further replies.
slubbock

slubbock

Programmer
Sep 23, 1999
4
NZ
:-( I need to extract data from an ORACLE 8i database via code and load it into an MSDE table.

I have been able to use ADO to connect to the ORACLE database and run a select query, but have been unable to either make or load the data into MSDE tables.

I also need to use the same method to update the MSDE tables.

In Access 97 you could link the table using ODBC and then write a 'MAKE' or an 'APPEND' query to get the data.

Any help would be appreciated.

SL.
 
Status
Not open for further replies.

Similar threads

combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
427
combo
combo
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
426
lameid
lameid
TrekBiker
  • Locked
  • Question
Records in one table not in another 1
Replies
3
Views
136
Andrzejek
Andrzejek
breezett93
  • Locked
  • Question
Field is being rounded in the export process
Replies
17
Views
333
strongm
strongm
breezett93
  • Locked
  • Question
Brand new lock violations errors all over my database
Replies
11
Views
571
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top