HTML Table import

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
I have a HTML document which contains a large data of data. When this html
file is imported into excel some of the columns get out of whack. eg. Some
columns are removed completely. This html renders ok in IE but get corrupted
or misread when imported into excel, mainly when the table gets big. eg. It
generally happens after the 10000 row mark.
Any suggestions?
 
All i do is write the content to a file called "test.xls" and then double
click on it.
This opens in excel and attempts to render the html.
If the file is called "test.htm" it opens in IE and renders fine.
The file is around 3MB of HTML (which i know is rather large), so i can
email it to someone if they want to check it out.

Ryan.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel external data range "failed to refresh" 0
excel external data range failed to refresh - second try 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
import html table ( which has been exported from sage line 50) 1
Excel 2010 Table not showing in Access 2010 Import List 0
Extract data from website code. 3
Stopping excel from converting numbers into dates on import 10
Importing several web pages with macro/VBA? 9

Back
Top