Pure SQL from MS Access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi There,

I'm a bit new to the world of using straight SQL code in MS Access (as
opposed to using the query builder).

Now, I have an Informix database that I'm working with, and I need to know
the steps in MS Access to paste an existing block of SQL code for use.

How do I do this?
 
Hi There,

I'm a bit new to the world of using straight SQL code in MS Access (as
opposed to using the query builder).

Now, I have an Informix database that I'm working with, and I need to know
the steps in MS Access to paste an existing block of SQL code for use.

How do I do this?

Create a new Query, not selecting any table; select "SQL" from the
dropdown icon at the left end of the query toolbar, or use View... SQL
on the view menu; copy and paste the SQL into this window.

Note that JET SQL and Informix SQL are two different dialects, and the
query may well fail to work without some tweaking.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Back
Top