How do I import a htm file into a table
Posted on 2015-01-31
A computer system that we use generates a weekly report that can be exported to excel. The file created has a .xls extension but when I open the file MS Excel says it's not in the correct format. Nevertheless it will open the file into a standard spreadsheet.
When I looked at the file with NotePad I realised it's actually a HTML file and if I change the extension to .html and launch it, it opens the spreadsheet in my web browser.
What I need to do is import the data into an Access table so I can then extract some of the data and save it in a format that we need for another application.