Get records from online database

[diwin]

I am fairly strong in coding VBA and ASP.

I have an ASP e-com site using Access and an offline Access database for managing orders, inventory, etc. which is based on the online database, but deviates a bit with respect to table structure.

When an order is placed online, we get an email with a link to the order details in a secure ASP page, and enter the order manually in the offline database.

What I would like to do is automate this. Is there a way, in one or very few steps to enable the online order to be harvested and entered in the offline database with the touch of a button?

I cannot find any discussion on connecting to an online database. I'm guessing there is a way to query the data from a form on an ASP page, but I am not sure how to package the data for the transfer.

Daniel Dillon
O o . (<--- brain shrinking at rate shown.)

 

[CautionMP]

diwin,
Just a thought, have the link with the "order details" point to an ASP page that returns XML, then grab and process the XML "with a touch of the button".

Once again, just a thought.

CMP

 

[diwin]

Thanks CMP.

ok. XML is something I haven't dealt with. So what do you mean by "an ASP page that returns XML"? Would I need to write a new ASP page? Would I then write a procedure in the offline database to locate and parse that page? Not sure how the pieces fit together.

Daniel Dillon
O o . (<--- brain shrinking at rate shown.)