Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
'translate' oracle sql to access sql
- Thread starter ClaudiaDi
- Start date
The SQL dialect used by Access is called Jet SQL (provided that you aren't using an Access project, which uses SQL Server as its back end).
Most ANSI compliant statements will work without changes, but key items are that Jet uses * instead of %, and ? instead of _ for wildcards in the LIKE statement.
More information is at
However, you will only really find the differences yourself if you try your original code in Access.
John
Most ANSI compliant statements will work without changes, but key items are that Jet uses * instead of %, and ? instead of _ for wildcards in the LIKE statement.
More information is at
However, you will only really find the differences yourself if you try your original code in Access.
John
Are you using Access as a front end (FE) to your oracle data or are you moving the oracle tables to access. If access is a FE to oracle then you can leave the oracle code as is and run it through pass thru queries. This will be much more efficient than trying to link the oracle tables with ODBC in access.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Question
