Using MS Query to Push Data to Oracle

[Chris Rettke]

I am comfortable with using MSQuery to pull data from
Oracle tables via ODBC connections. I am now at a point
where I would like to be able to load data to an Oracle
table from an Excel file. I already have working ODBC
connectinos to pull, just want to turn around and be able
to push. Is this possible, and if so is it possible
without VBA?

Thanks

c-

 

[K Dales]

-----Original Message-----
I am comfortable with using MSQuery to pull data from
Oracle tables via ODBC connections. I am now at a point
where I would like to be able to load data to an Oracle
table from an Excel file. I already have working ODBC
connectinos to pull, just want to turn around and be able
to push. Is this possible, and if so is it possible
without VBA?

Thanks

c-
.

Possible: Yes, assuming your UID and password give you the
proper security access to add data to the Oracle tables.
Possible without VBA? Yes, but you would need the proper
tools. MSQuery is designed as a data lookup tool, not for
data input. If you know SQL you can edit the SQL query in
MSQuery and perhaps (I have not tried it) get it to append
records that way, but this is not a very easy or good way
to do what you want. Microsoft Access would be a better
tool - you could link your Excel data into an Access table
and link the Oracle DB tables in as well, then use Access
append or update queries to modify the data. But if you
want to stick with Excel, VBA (with ADO) would be the way
to go, and this would require pretty extensive coding.