Obstacle:
I've recieved a large shipment of gift certificates, and would now like to
'import' them into a table. Say I've recieved a bill of lading suggesting
we've recieved a shipment of serial #1000 to #5000

Anybody have any suggestions, or starting points, as to how I can import (or
update?/append?) these records into the table, by creating some sort of
'starting ID' and 'ending ID' query, where the table will then automaticially
have the new values added?

greatly appreciated, DMcDaniel (fellow glutton-for-good-punishment, Access
wannabe-guru )

"DMcDaniel" <(E-Mail Removed)> wrote in message
news:EAA999CA-74D5-4671-A1B7-(E-Mail Removed)...
> Obstacle:
> I've recieved a large shipment of gift certificates, and would now like to
> 'import' them into a table. Say I've recieved a bill of lading suggesting
> we've recieved a shipment of serial #1000 to #5000
>
> Anybody have any suggestions, or starting points, as to how I can import
> (or
> update?/append?) these records into the table, by creating some sort of
> 'starting ID' and 'ending ID' query, where the table will then
> automaticially
> have the new values added?
>
> greatly appreciated, DMcDaniel (fellow glutton-for-good-punishment,
> Access
> wannabe-guru )
>
>
>

On Mon, 27 Apr 2009 17:23:01 -0700, DMcDaniel
<(E-Mail Removed)> wrote:

>Obstacle:
>I've recieved a large shipment of gift certificates, and would now like to
>'import' them into a table. Say I've recieved a bill of lading suggesting
>we've recieved a shipment of serial #1000 to #5000
>
>Anybody have any suggestions, or starting points, as to how I can import (or
>update?/append?) these records into the table, by creating some sort of
>'starting ID' and 'ending ID' query, where the table will then automaticially
>have the new values added?
>
>greatly appreciated, DMcDaniel (fellow glutton-for-good-punishment, Access
>wannabe-guru )
>
>

If you really NEED this... i.e. if there is something other than the serial
number which will (at some point) differentiate the records... you can do this
easily with the help of a little auxiliary table. I'll routinely add a table
named Nums, with one long integer primary key field N; this can be manually
filled using Excel. Use the Excel Insert... Fill... Series feature to put
values from 0 through 10000 (or 65536) in Column A; import this spreadsheet
into the table Num. You only need to do this the first time you add it, just
import it from another database thereafter.

You can create an Append query such as

INSERT INTO Certs
SELECT [N] + [Forms]![SomeForm]![txtStart]
FROM Nums
WHERE [N] < [Forms]![SomeForm]![txtHowMany];

and run it from a form with unbound textboxes to solicit the desired range of
values.
--

John W. Vinson [MVP]