|
|
 |
|
|
Pages: 1
Web Page Data Import To Access Database
(Click here to view the original thread with full colors/images)
Posted by: iuotis
I am attempting to import a webpage table of data (Engineering Change Notice Listing) into MS Access. I thought there was a way to automate the process of importing the information once the login process was accomplished. However, I can't get the web page data to parse into the appropriate Access fields.
I tried using EXCEL first, with the intention of pulling into Access from Excel; however, again the web page data ended up in one column in Excel.
Any suggestions or help is greatly appreciated.
Thanks,
Gary
Posted by: arturo238
Try using Frontpage instead. It should import the code without any problem. If you don't have frontapge then try Word. It has a rudementary HTML editor that can copy pages but I would not suggest trying to edit the page with Word. Ocne you have the page in an office program, then you should be able to use the file import wizard feature in the Office program group to import the data to Acess. Hope this helps.
|
|
|
|
|