importing SQL instructions

  • Thread starter Thread starter macdoum
  • Start date Start date
M

macdoum

Hello.

I've saved a SQL instructions file from Oracle's Querry Builder. I was
wondering if it was possible in any way to import those instructions
into a Ms Access query ?

Thanks,

Marc-André.

(e-mail address removed)
 
macdoum said:
I've saved a SQL instructions file from
Oracle's Querry Builder. I was wondering
if it was possible in any way to import those
instructions into a Ms Access query ?
Click to expand...

Not "import" but if you have them in text form, you should be able to copy
and paste them into the SQL Property of an Access Query. Just don't expect
them to work, because all DB's have their own "dialect" of Standard SQL, so
you will likely have to modify before you get it working. IIRC, Oracle is
known for having some "extensions" to SQL, and Jet certainly has some
differences.

Larry Linson
Microsoft Access MVP
 
They may not work directly, there may be some syntax changes you need to
make. I haven't used Oracle, so I don't know. The easiest way to import them
may be to open the Access query in SQL view and copy and paste the SQL text
of the Oracle query.

You may come closer to being able to use them without syntax changes if you
go to Tools|Options|Tables/Queries tab and check the box for using SQL
Server Compatible Syntax. However, if you've created other queries in the
database already, doing this may require syntax changes in those.

--
Wayne Morgan
MS Access MVP


Hello.

I've saved a SQL instructions file from Oracle's Querry Builder. I was
wondering if it was possible in any way to import those instructions
into a Ms Access query ?

Thanks,

Marc-André.

(e-mail address removed)
 
if you used a real tool like SQL Server it would be easy to send some
TSQL script.

Access Data Projects look and feel JUST LIKE mdb but it's a much much
richer database experience.

and doing things like sending DDL scripts against SQL Server?

it is quite easy with either ISQL or SQLCMD through the command line.

-Aaron
 
Back
Top