S
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.
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.