Re: SQL from access
Date: Tue, 20 Nov 2001 05:22:32 GMT
Message-ID: <sMlK7.33603$gQ1.13660205_at_news1.elmhst1.il.home.com>
Access basterdizes SQL somewhat, which is OK if you're using it just in Access. Actually, I've often used Access to quickly generate SQL queries that I use in SQL Server. What I do is create the query, then strip out the code I know won't be recognized in SQL Server. Perhaps a small program could be written in Access VB Code to search and replace such code.
"John Fu" <zenki198_at_yahoo.com.au> wrote in message
news:8byB7.216251$bY5.958168_at_news-server.bigpond.net.au...
> I've been developing ASP pages whilst using MS Access. However, recently,
> my clients changed their minds and wanted it to be implemented in Oracle.
> Now I have around 130 odd pages, and each one of them has Access SQL
> statements in them.
>
> Now I was just wondering, instead of rewriting all the SQL statements into
> ANSI SQL statements, are there any ways that could speed up the process?
So
> I guess I'm just asking, are there any short cuts to this? If so, please
> reply. Or if you have any good ideas that you can spare, please tell me.
>
> Thanks very much.
>
> John.
>
>
Received on Tue Nov 20 2001 - 06:22:32 CET