Oracle ODBC and VB 5 (insert into (select * from) problem)

Hi,

I am working on a project that needs to copy an Access table to an Oracle database within a VB5 (4 would do the same) program.

My ODBC connection works fine because I can select / delete / insert / update to my Oracle database...
Now, since I have to copy a table from on db to another, I am using a insert into (select * from) command...
BUT, I think I'm missing something from a syntax point...

Here's my code
conn.Execute ("insert into dest
[ODBC;UID=my_username;PWD=my_password;DSN=my_dsn] (select * from source)")

where dest is the table on the Oracle dB and source the table on the Access dB.
Of course, conn is an opened Access connection!

So, I guess my syntax is wrong, and I'd be very thankful to anybody who could help me (as there isn't that much of information in the VB help!)

PS: An email reply is preferrable

Fred Hurtubise
fhurtubi_at_videotron.net
Internet Programmer / Oracle Developper Received on Mon Apr 27 1998 - 16:43:24 CDT