| Author |
Quey in Access using VB6?
|
|
| Pharoh 2006-04-26, 6:56 pm |
| I have a small access database and I wanted to basically write a query
in vb6 that selects from one of three tables and 'Appends' the records
to an Oracle db with matching fields. I will eventually relplicate the
code to perform the same task over all three tables in the access
database.
i was just wondering what the proper way to do this was?
thanks much
| |
| Jeff Johnson 2006-04-26, 6:56 pm |
|
"Pharoh" <mluedey@hotmail.com> wrote in message
news:1146062856.922899.97090@v46g2000cwv.googlegroups.com...
>I have a small access database and I wanted to basically write a query
> in vb6 that selects from one of three tables and 'Appends' the records
> to an Oracle db with matching fields. I will eventually relplicate the
> code to perform the same task over all three tables in the access
> database.
>
> i was just wondering what the proper way to do this was?
Well, it could be as easy as linking the Oracle tables to your Access DB and
then doing an INSERT query. Why go to the trouble of using VB for this?
| |
| Pharoh 2006-04-26, 6:56 pm |
| they want a solution that can be used again down the road...
| |
| Jeff Johnson 2006-04-26, 6:56 pm |
| "Pharoh" <mluedey@hotmail.com> wrote in message
news:1146069262.491432.159400@e56g2000cwe.googlegroups.com...
> they want a solution that can be used again down the road...
Well, my first question is "What have you tried?" Basically you'll need to
open one recordset against your Access table and another against your Oracle
table and then loop through the first, adding rows to the second.
|
|
|
|