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...
Furthermore, as far as my database design is concerned
what tables would I need? I currently have a Data table
and this contains the ID, RegMark, Make, Model, Year, CC,
LoginID etc... I also have a Login table and this
contains the LoginID, Name, Address etc.. for each person
that is setup to use the system.
Help will be appreciated.
skc
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...
Furthermore, as far as my database design is concerned
what tables would I need? I currently have a Data table
and this contains the ID, RegMark, Make, Model, Year, CC,
LoginID etc... I also have a Login table and this
contains the LoginID, Name, Address etc.. for each person
that is setup to use the system.
Help will be appreciated.
skc