Re: Oracle/MS SQL Interface

Hi

You may want to look at using a linked server, see Books online for more
information.

John

"brogdonm" <Brogdons@xxxxxxxxx> wrote in message
news:1135714953.066647.272150@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Hi everyone. I need to be able to query a database in Oracle and then
> actually save the data in an MS SQL database, does anyone know what is
> the best way to do this? Would it be best to do everything internal
> (inside MS SQL) or external (with some script: javascript, vbscript,
> perl)?
>
> Thanks in advanced,
> Mike
>


.

Relevant Pages

  • Re: SQL vs. Access
    ... I can't say I know the rules in depth, but typically if you are using /linked/ tables in Access and you're not using a "pass-through" type query, then Access could be reading all the data it "thinks" is necessary to do the necessary joining/filtering, which may require a lot of data to pass between our SQL database and Access, which could I assume lead to behaviour which either looks like a hang or is a hang. ... Security. ... plain text logon/password information into your Word file or a .odc file. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Autonumber needed in form when new record opens
    ... > frustrating. ... >>> SQL database with Access Project ... can you update records in it? ... >> query? ...
    (microsoft.public.access.modulesdaovba)
  • Re: Autonumber needed in form when new record opens
    ... >> SQL database with Access Project ... > query, can you update records in that query? ... > Dirk Goldgar, MS Access MVP ...
    (microsoft.public.access.modulesdaovba)
  • sql query for excel column values
    ... I have a spreadsheet that I receive daily. ... 50-1000 values in column A that I need to query an sql database for. ... A2, do the query, return the results to a new workbook, and continue down the ... I set it up so that it queries each cell value until the end of the data? ...
    (microsoft.public.excel.programming)
  • Asynchronous access problem
    ... I have a form that queries a SQL database and updates an Access table through ... This procedure is run on demand. ... I run an update query to clear out the data in the table that my ...
    (microsoft.public.access.formscoding)