Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jtwork
Yak Posting Veteran
82 Posts |
 Posted - 2008-11-13 : 06:24:42
|
| SQL Sever 2000I would like to set up an active x script to run a query against an oracle v10 server and pull the results into a pipe delimited file onto my sql server where i will then run a bulk insert. I am already using an open query but this isn't very efficient and i don't have access to the oracle box to push the data. Is anyone able to assist? |
|
|
jtwork
Yak Posting Veteran
82 Posts |
Posted - 2008-11-14 : 04:24:03
|
| Is anyone able to point me in the right direction with this query? |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-11-14 : 05:15:54
|
ActiveX script?Why not simply use the IMPORT/EXPORT wizard?Or save the code generated by the IMPORT/EXPORT wizard?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
pull of data from oracle using active x