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 SkipVought 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
0
0
NZ
Visit site
:-( 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

Moss100
  • Question
Filter vba problem
Replies
0
Views
87
Moss100
Moss100
Omarahmed22
  • Locked
  • Question
VBA Formating
Replies
1
Views
97
Andrzejek
Andrzejek
TheAceMan1
  • Locked
  • Question
Delete from listi n XL open tab with VBA
Replies
2
Views
114
TheAceMan1
TheAceMan1
bobbyer
  • Locked
  • Question
Ms Access VBA Automatic Relinking Frontend to 2 Backend via form
Replies
13
Views
185
bobbyer
bobbyer
Moss100
  • Locked
  • Question
Vba adding record to table when field is integer
Replies
8
Views
136
Moss100
Moss100

Part and Inventory Search

Sponsor

Back
Top