Sunday, February 19, 2012

Importing Access 2000 queries

Hello,
Brand new to SQL. I got all my data over to the SQL database. Is there a
way to get the access queries into SQL?
Thanks,
Gale
"Gale Coleman" <gcoleman@.legalassist.org> wrote in message
news:uxh9DkRkEHA.3828@.TK2MSFTNGP10.phx.gbl...

> Brand new to SQL. I got all my data over to the SQL database. Is there a
> way to get the access queries into SQL?
Access queries may or may not translate depending on how they are written.
On the SQL Server side, to access or manipulate data you have the option of
creating Views or Stored Procedures. Views are probably closest to Access
queries, and even have an 'SQL' window display of the query (you could try a
copy/paste of the Access query to a view as a starting point).
Steve

No comments:

Post a Comment