...

View Full Version : importing dynamic table data from a web page



gobez
12-11-2003, 02:29 PM
I need to import dynamic data from an .asp page on my company site into an access table on our company server, preferably by clicking a link on the .asp page.

I know it's perfectly possible to import static table data but I'm having trouble with dynamic data.

Any ideas?

Cheers in advance,

Gobez

A1ien51
12-11-2003, 02:39 PM
how is this dynamic data placed on the asp page?

gobez
12-11-2003, 02:43 PM
Originally posted by A1ien51
how is this dynamic data placed on the asp page?

Hi,

The Dynamic Data is bound to text fields that are placed in table cells.

A1ien51
12-11-2003, 03:01 PM
That would be rather easy then, if I had time I would write a basic framework, but I am sort of behind at work today.

Basically you need to have a form submitted by clicking the link or button.

The form would then run a basic Insert query into the database by looping through the rows of elements on the page.

Wish I could help you more,
Eric

gobez
12-11-2003, 03:40 PM
Sorry A1ien51, I've misled you :o. I didn't mean company server as in our web server I meant the local server in our office where our PC's are networked!

Basically:

Data captured from clients into the DB on our website needs to be downloaded into a specific table in the DB on my machine. I'll process the data from there. I could just download the entire DB from the web server but it seems a mighty process for individual client info.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum