troubleshooting Question
Importing HTML Multi Row into access (VBA?)
asked on
I have an HTML document that has two lines per record. As you can see from the enclosed, the fields are not necessarily full for both lines.
I need to bring these into a new (or existing) table so they can be analyzed. In the enclosed you will see the location of text that is filled sometime and empty on others (Pips4idiots,LTP[tp], LTP, LTP[sl]) this can vary and is not limited to the three shown as an example. IN addition to the text, I would like to bring in the other fields.
I'm not extremely familiar with HTML, but have coded VBA and am fairly proficient at Access.
As this HTML format will always be the same format, I would like to have something that a user would just click on, select the file and it would import it. I can do everything up to the import. I dont know how best to handle the HTML and the two lines.
Any help would be appreciated.
demo.jpg
I need to bring these into a new (or existing) table so they can be analyzed. In the enclosed you will see the location of text that is filled sometime and empty on others (Pips4idiots,LTP[tp], LTP, LTP[sl]) this can vary and is not limited to the three shown as an example. IN addition to the text, I would like to bring in the other fields.
I'm not extremely familiar with HTML, but have coded VBA and am fairly proficient at Access.
As this HTML format will always be the same format, I would like to have something that a user would just click on, select the file and it would import it. I can do everything up to the import. I dont know how best to handle the HTML and the two lines.
Any help would be appreciated.
demo.jpg
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 11 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.