sql insert into

  • Thread starter Thread starter 1aae
  • Start date Start date
1

1aae

Thank you
How can I use insert into to insert to field fserail from 1:100
insert into fserial (1:100)
example what field should be
fserial:
1
2
3
etc
this example only not for making serial
 
Thank you
How can I use insert into to insert to field fserail from 1:100
insert into fserial (1:100)
example what field should be
fserial:
1
2
3
etc
this example only not for making serial

Unless you have an auxiliary table, this can't be done directly with
SQL. Three suggestions:

- Create a table Num with a single field N, values 1 to whatever (I
use 10000 but it can be any desired size); run an Append query.

- Open Excel; type 1 in cell A1, select cells A1 through A100, and
choose "Fill Down" from the Insert menu. Copy and paste into your
Access table.

- Write a VBA function to open a recordset and insert records.
 
Back
Top