I am used to Oracle using a SQL interface and writing files with many SQL statements and then executing the file in Oracle SQL Plus.

I need to do some work in Access2003 but cannot find the SQL window where I can type SQL and more importantly where I can import and execute pre-written SQL files.

For instance I have a SQL text file containing all tables I want to create.

How do you execute that in Access 2003 interface?

From memory, starting from a new query in design view, click on View/SQL View.