Insert into? (1 Viewer)

[chrisguk]

I have a database that contains a list of items with a code assigned to them.

Every other week I receive activation numbers for these items on an excel spreadsheet. Without type each on into the database is there a way I can automate the process using an SQL statement insert into, also I would like this to be driven from a form:

Example data:

Insert into Item1, Item2 myDB where Item1 = ImportItem1 or something similar

 

[John Big Booty]

Perhaps the sample posted here will give you some pointers.

 

[chrisguk]

Perhaps the sample posted here will give you some pointers.

Hi many thanks for your reply, this option looks great. Are you able to post a Access 2000 version for me please?

 

[John Big Booty]

Try that Now in 2000

...and be sure to copy both the Access and Excel files to the same location