VBA EXCEL SQL CREATE TABLE syntax

Question

Can someone please help me with the following line. I am trying to create a table that will have a column with the Id that automatically increments when a record is inserted. This is for microsoft access.

"CREATE TABLE " & tblName & " ([P_Id] integer not null AUTOINCREMENT(100, 5))"

The following command doesn't work from w3schools.com .Execute "CREATE TABLE " & tblName & " ([P_Id] PRIMARY KEY AUTOINCREMENT — engineer Mike
– engineer Mike, Commented Nov 20, 2012 at 21:56

ron tornambe · Accepted Answer · 2012-11-20 22:00:12Z

1

Try the following to create an MS Access table with an auto-number field:

"CREATE TABLE [" & tblName & "] ([P_Id] integer not null IDENTITY)"

I do not know if you can specify a start-value and increment, but you can try it.

edited Nov 20, 2012 at 22:00

answered Nov 20, 2012 at 21:53

ron tornambe

10.8k8 gold badges38 silver badges61 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

ron tornambe Over a year ago

Hi Mike, I know you are new to SO, but when you receive a correct answer you should "accept" the answer. This will increase your "accept percentage" and add 2 points to your reputation.

engineer Mike Over a year ago

Thanks Ron, I am new. I was amazed at how fast I got answers. It was almost like everyone was just waiting for me to ask a question. How do I see the tags that I may be able to contribute?

ron tornambe Over a year ago

SO is remarkable. I strongly suggest you read and digest the FAQ (stackoverflow.com/faq).

Collectives™ on Stack Overflow

VBA EXCEL SQL CREATE TABLE syntax

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related