CODEWITHSUNDEEP
ms-accessms-access-2013ddl
lmb57
lmb57

Reputation: 41

How to run DDL in Access 2013?

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.

Upvotes: 4

Views: 2611

Answers (1)

Gord Thompson
Gord Thompson

Reputation: 123809

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

DDL.png

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

Upvotes: 8

Related Questions