Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using MS Query to Push Data to Oracle
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- |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using MS Query to Push Data to Oracle
-----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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS Query Oracle syntax | Excel Discussion (Misc queries) | |||
MS Query Oracle syntax | Excel Discussion (Misc queries) | |||
Pivot Table, MS Query and Oracle | Excel Discussion (Misc queries) | |||
How to update ORACLE query definition in Excel file | Links and Linking in Excel | |||
OLE DB Query Table to Oracle using Parameters | Excel Programming |