Access 2000- Import Question

[skc]

I have a table that contains car registration plates that
are entered everyday into frontpage forms on the web.
These are posted into a Access table. I then have a query
to extract only registrations that begin with a 'X' and
these are sent to an external agency (pasted into Excel
from a FPRW .asp page) who then populate the spreadsheet
with extra fields (Make, Model, Year, CC etc...).

I then want to paste back into my table only those files
that are on the spreadsheet.

Is there a special statement I can use in Access, to read
my Spreadsheet and post into the fields the data that I
require. E.g., X234JJD (Access) --> X234JJD (Excel) then
copy all the data into the fields Make, Model, Year...

Help will be appreciated.

Thanks.

 

[david epsom dot com dot au]

Yes, you can link to spreadsheet as a table. Select File,
Get External Data.

(david)