Adding Multiple Records; No External Data Source - Query?

  • Thread starter Thread starter DMcDaniel
  • Start date Start date
D

DMcDaniel

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 said:
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 :) )
Click to expand...
 
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 :) )
Click to expand...

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.
 
Back
Top