multiple table creation in Access

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

Guest

I want to create multiple table(s) in Access database at one go. How can I do
it? Access permits to create only one table at a time using Query/Design. I
am giving below the 3 SQL statements for which I want to create 3 tables in
Access at one go.

1. CREATE TABLE gk1(C_ID INTEGER NOT NULL, EFTV_DT DATE NOT NULL);

2. CREATE TABLE gk2 (EXT_NUM CHAR(20) NOT NULL, C_ID INTEGER NOT NULL);

3. CREATE TABLE gk3 (U_ID INTEGER NOT NULL,C_ID INTEGER NOT NULL);

Can someone help me how to create multiple tables under an access DB, using
some tool or otherwise.
 
Hi,


You create one after the other:

CurrentDb.Execute strSQL1, dbFailOnError
CurrentDb.Execute strSQL2, dbFailOnError
CurrentDb.Execute strSQL3, dbFailOnError




Hoping it may help,
Vanderghast, Access MVP
 
Back
Top