Create a table of 1 column for integers 1 to 2000

[Mel_P]

This should be simple but brain dead!

In the end I used Excel and typed 1, 2, 3, 4 etc and stretched it to 2000 rows and pasted it into Acess.

What is the SQL in Access to create a single column table of integers please?

INSERT INTO..... ???

Thanks, Mel

 

[khawar]

I have attached a sample for you

 

[namliam]

Excel by far is the easier solution for this though Then copy paste and done.

 

[MStef]

Look at "Demo1To2000A2000.mdb" (attachment,zip).
Look at Query1, Module1, Form1 (vba).
Not to do it twice.
Do it only via Form1 (IMPORTANT).
Open form1 and try.

 

[Mel_P]

I have attached a sample for you

Thanks - I understand this process, Mel

 

[Mel_P]

Look at "Demo1To2000A2000.mdb" (attachment,zip).
Look at Query1, Module1, Form1 (vba).
Not to do it twice.
Do it only via Form1 (IMPORTANT).
Open form1 and try.

Thanks - a bit more complex!

Excel was easier !!!!