knarlyd@hotmail.com
Registered User.
- Local time
- Today, 12:35
- Joined
- Sep 6, 2013
- Messages
- 43
I have HTML files that end in with the extension .xls
They do not have field names in the first row.
When you attempt to open one in Excel, it coughs a bit with an error and then opens them (since they're HTML). I can then save the spreadsheet, then import w/o issue into Access. But I don't want the end user to have to open it Excel, then save it.
With that said, is there a way to take that .xls file that contains HTML data and import it into an existing (or new) table in Access using VBA?
I've searched high and low
and haven't found anything to help thusfar.
Any vba code would be *greatly* appreciated!
They do not have field names in the first row.
When you attempt to open one in Excel, it coughs a bit with an error and then opens them (since they're HTML). I can then save the spreadsheet, then import w/o issue into Access. But I don't want the end user to have to open it Excel, then save it.
With that said, is there a way to take that .xls file that contains HTML data and import it into an existing (or new) table in Access using VBA?
I've searched high and low
and haven't found anything to help thusfar.Any vba code would be *greatly* appreciated!
