entering SQL into Access 2000

Finally remembered how to submit a SQL line to an Access database. I knew it was possible just couldn’t remember how to do it.

  1. In the Database window, click Queries under Objects, and then click New on the Database window toolbar.
  2. In the New Query dialog box, click Design View, and then click OK.
  3. Without adding tables or queries, click Close in the Show Table dialog box.
  4. In the View menu (at the top) click on SQL View.
  5. Type in (or copy and paste) your SQL.
  6. Click the red exclamation point or go to the Query menu and click Run.

Do that as many times as you need to and skip all the M$ stuff tha gets in the way.

del.icio.us:entering SQL into Access 2000  digg:entering SQL into Access 2000  furl:entering SQL into Access 2000  reddit:entering SQL into Access 2000

Leave a Reply