I have an asp page on a website which holds the results of a questionaire form and I want to import this into an Access database.
There will be several sets of responses on the asp, each with a header of 9 cols and the body of many lines and 5 cols.
How can I get this to import into Access, or would it be better to get it into Excel first, split out the headers and then import ino Access?
Either way, how do I get it from the web onto my PC?
If this has been posted before please give me the reference - I have searched here but cannot find it.
Thanks in advance guys!!
There will be several sets of responses on the asp, each with a header of 9 cols and the body of many lines and 5 cols.
How can I get this to import into Access, or would it be better to get it into Excel first, split out the headers and then import ino Access?
Either way, how do I get it from the web onto my PC?
If this has been posted before please give me the reference - I have searched here but cannot find it.
Thanks in advance guys!!