View Single Post
  #1   Report Post  
Tom
 
Posts: n/a
Default import web table to excel

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/myquotec...27-318132.html .
Thanks -
--
Tom