import web table to excel

T

Tom

I have read how to import tables on the web to Excel, but I have a problem:
when the table data is imported, the columns from the web table are placed
successively after each other in Col A in Excel, and the row boundaries are
not maintained, instead, each line of data within each cell of the table
becomes a row in Excel. Is there a way a) to get the import wizard to place
the successive columns from the talble into successive cols in Excel, and b)
to preserve the rows, so that multiple lines within a cell will remain that
way after importing to Excel, instead of being imported as multiple cells?
Ref: URL:
http://www.insuremytrip.com/myquotecalc-package-1000-0-13027-318132.html .
Thanks -
 

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

Top