Question...

[JohnH]

I have a question...

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

Please help.

JohnH

 

[Thomas A. Rowe]

To learn how to import data into Access from Excel, suggest you post to the Access or Excel
newsgroup, as this is not a FP related question.

This is not something can not be done with FP the FP database components, and to do it with
ASP/VBScript requires a knowledge of ASP/VBscript to write the custom coding required or you will
need to hire a ASP/VBScript programmer.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================