Prev: Close on Lost Focus
Next: dasc
From: Lloyd McClure on 3 Feb 2010 12:49

How do I fill a column with sequential numbers [1 to 400] in an Access
table that
I can copy and paste to another Access table? No auto-number.
Thanks, Mac


From: Jeff Boyce on 3 Feb 2010 14:48
Lloyd

This might strike you as a rather round-about way, but it's fairly simple.

Open an Excel spreadsheet. Create your column of sequential numbers. Close
and save.

Open Access. Import the spreadsheet you just made as a table.

(now that you know how, are you willing to let us know "why"? What will
having 400 sequential numbers in a table in Access allow you to do?)

Regards

Jeff Boyce
Microsoft Access MVP

--
Disclaimer: This author may have received products and services mentioned
in this post. Mention and/or description of a product or service herein
does not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

"Lloyd McClure" <popco(a)toast.net> wrote in message
news:gpdjm5t9lk60usnod18sfslq7pj1fcrerm(a)4ax.com...
>
> How do I fill a column with sequential numbers [1 to 400] in an Access
> table that
> I can copy and paste to another Access table? No auto-number.
> Thanks, Mac
>
>


 | 
Pages: 1
Prev: Close on Lost Focus
Next: dasc