Posting and updates

[johnH]

Hi,

I am using FP2000 with an Access backend database. I have
a webform that records car number plates - we input around
200 in 1 day.

I then have a simple .asp page that lists all the car
plates entered with Timestamp filtered for plates
beginning with 'X' and this is copied and pasted into
Excel and sent to a processing centre.

The processing centre enrich the spreadsheet, adding Make,
Model, Engine Size etc... I then need to paste this data
back into Access for the records that have enriched data.

What is the best way of doing this? The more I think
about this the more I am getting into a muddle!

Thanks,

John

 

[Kathleen Anderson [MVP - FrontPage]]

Do the people at the processing center have access to the web site? You
could make a second asp page for them that brings up the records and lets
them add the rest of the information to the database in the web.

 

[johnH]

They would not want to input records by hand. Instead
they would run the registrations against their database
and extract an enriched spreadsheet. This sheet would
then need to be imported into my database - which is the
problem here, as I do not know how to automate this part
of the process!!