How to run DDL in Access 2013?

Question

I need to run DDL script to create tables to import data into Microsoft Access. I have the DDL script already made and it has worked in Oracle SQL Developer already, but I'm looking to do it in Access as well.

I can't seem to find an easy way to do it. It looks like previous versions of Access had this feature.

Answer 1

Probably the easiest way to run a DDL statement in Access 2013 is to choose

CREATE > Query Design

from the ribbon, hit Esc to dismiss the "Show Tables" dialog, click the "Data Definition" button on the ribbon

type or copy the DDL statement into the query pane, then click the "Run" button on the ribbon (big red exclamation point).