Help with Transfer HTML that has .xls file format in Access 2010 using VBA

[JDenham]

I have a downtime system that was created by our IT department that records the downtime of the line stops, it has export to excel button that will export the downtime to excel based off the parameters of date and time. I want to do the export then import to access for downtime analysis. The problem I am having is the programmers export it as HTML with .xls file format. and the worksheet has a date associated with it as well as the spreadsheet has a tab that contains a date and I can't figure away to import to a fixed table. So I tried the transfer spreadsheet not knowing it was in HTML, couldn't recognize the format, then I tried transfer HTML, can't find the file because of .xls file format. I know I could re-save it as a excel file but was trying to keep the steps to a min. Is there a way to import even though it has a date attached to the file and spreadsheet tab. Any suggestions will be very much appreciated.

[ItsMe]

What is the file extension of the file you wish to import? Is an html file embedded within a cell?

[JDenham]

It has a file extension of .xls, but it is html embedded

[ItsMe]

There are ways to parse data within html files, but it requires advanced programming techniques. Is it possible to request a tab delimited export or even csv from the programmers?

[JDenham]

I have ask for help on this matter, 2 months ago, as of yet no solution. To their credit they are short manpower and my problem is of low priority.

[ItsMe]

Well, if you have VBA and Java experience I can show you how to get it done. Otherwise, you would have a steep learning curve. It is doubtful (if I were to manage the entire thing on my own) I would be able to complete the task in under 14 hours (in 2 days). It depends on if everything is stored within a single table element in the html.

I would recommend getting some professional help. The other option is to get the export as a text file. So CSV, Tab Delimited, or Fixed Width.

With a text file, we could walk you through it, easily.

[JDenham]

Ok, that is kinda what I thought, thanks for your help

[ItsMe]

You bet...