Hi,

 

I've received an xls spread sheet to put into my site. I have never done this before but looked online and then on Dreamweaver and copied the unformatted table data into the "insert - table object - import tabular data"

 

Surprised that for once something worked! Almost... Most of the data has been put nicely into columns and rows but then some data has been clumped together. There are 132 rows in total and 5 columns.

 

I can see how to edit the data in order to separate them all into rows but there is so much I'd be here all night. Here is a snippet of what code went right and what went wrong. I don't know if the line breaks are meant to be there but why has it worked with the first section and the last but not the middle?

  <table border="1">
  <tr>
	<td>DESCRIPTION</td>
	<td>SECTION</td>
	<td> </td>
	<td>PRICE </td>
  </tr>
  <tr>
	<td> </td>
	<td> </td>
	<td> </td>
	<td>ex vat (each)</td>
  </tr>
  <tr>
	<td> </td>
	<td> </td>
	<td> </td>
	<td> </td>
  </tr>
  <tr>
	<td>Spare tyre holder (possibly Kestrel/Alpine)</td>
	<td>Bodywork</td>
	<td> </td>
	<td>10</td>
  </tr>
  <tr>
	<td>water powered in car heater (Smiths)</td>
	<td>Bodywork</td>
	<td> </td>
	<td>10</td>
  </tr>
 >
  <tr>
	<td>air 8" headlights	Bodywork		240<br />
	  Windscreen wiper motor	Bodywork		40<br />
	  Large Rotax Headlamps (10 inch)	Bodywork		550<br />
	  Spun brass dynamo cover (unused)	Bodywork		50<br />
	  Front louvred aprons	Bodywork		10<br />
	  Drum brake backing plates	Brakes		20<br />
	  Brake drum back plates	Brakes		10<br />
	  Brake backing plates (racing new)	Brakes		100<br />
	  Large brake drums (Possibly from Riley Tourer)	Brakes		20<br />
	  Foot brake assemblys	Brakes		80<br />
	  Hand brake assembly	Brakes		45<br />
	  Various Riley foot pedals	Brakes		30<br />
	  Brake Drums	Brakes		12<br />
	  Standard Riley Brake shoes	Brakes		15<br />
	  Std Riley brake drums	Brakes		20<br />
	  Brake Shoes	Brakes		15<br />
	  Riley 9 Radiator honey comb	Cooling		50<br />
	  Radiator thermostate assembly	Cooling		30<br />
	  Complete 6 cyl radiator (good condition)	Cooling		350<br />
	  Monaco complete radiator (good condition)	Cooling		160<br />
	  Riley 9 radiator complete	Cooling		120<br />
	  Large chrome radiator surround	Cooling		70<br />
	  New quick release radiator cap (bare casting)	Cooling		80<br />
	  Radiator cap	Cooling		25<br />
	  Riley 6 Cylinder radiator honey comb	Cooling		70<br />
	  Radiator fans	Cooling		30<br />
	  Smiths 4 rev counter</td>

How did you copy the data?

 

To try it, I saved an Excel file to CSV format, then imported it (the CSV) into DW - 100% successfully

Yay thank you it worked!!!

 

Before I was copying the table data in to text edit to un format it then putting the text file in the tabular data. I read that on another site where a girl had the same problem but she was using Front Page whereas I use DW. It kind of worked but at least this one works perfectly :-)