Open Tech Support
Open Tech Support Archives
Back to HomeCommunityReviewsGuidesDownloadsTech LinksMarketplaceContact Us
 »  SITE NAVIGATION
»  OTS Home
»  OTS Forums
»  OTS Archives

»  About our site
»  Search our site
»  Support our site

»  What is this site?
»  Who are we?
 
 
 »  ADVERTISMENT
 
  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.



 
Copyright 2000-2008 Open Tech Support.  All Rights Reserved.  Site Design and Development by Tolitz Rosel.