Excel - acces table link

Dear All

I want to connect an Excel table with an Access table so when I make changes to excel table these changes to appear in the access table and use the access table for my web site.
The excel table looks like:

RoomType20/04/06-31/05/0601/06/06-30/06/0601/07/06-14/09/0601/10/06-31/10/0615/09/06-30/09/06Standard Room Single108131161Standard Room Double120146179Standard Room Triple161193237Apartment Double156189234Apartment Triple211255318Maisonette Double166206255

and the access linked result looks like

RoomType20/04/06-31/05/0601/06/06-30/06/0601/07/06-14/09/06#Number!
#Number!

Standard Room Single108131161Standard Room Double120146179Standard Room Triple161193237Apartment Double156189234Apartment Triple211255318Maisonette Double166206255Maisonette Triple227278345Junior Suite Double199240288Junior Suite Triple268321385






















All is comming well except from the second line where access expects different type of data.
If I import the data instead of linking the result is all ok but this way when I make changes in the excel table the changes do not appear in the access table
Any idea how to solve this problem, or is there another way to do this liking?

Mery Christmas to all

Sorry I can see that the data was not the sam eway I typed so I repeat

Excel table looks like

RoomType 20/04/06-31/05/06 01/06/06-30/06/06 01/07/06-14/09/06
01/10/06-31/10/06 15/09/06-30/09/06
Standard Room Single 108 131 161
Standard Room Double 120 146 179
Standard Room Triple 161 193 237
Apartment Double 156 189 234
Apartment Triple 211 255 318
Maisonette Double 166 206 255
Maisonette Triple 227 278 345
Junior Suite Double 199 240 288
Junior Suite Triple 268 321 385

and Access table looks like

RoomType 20/04/06-31/05/06 01/06/06-30/06/06 01/07/06-14/09/06
#Number! #Number!
Standard Room Single 108 131 161
Standard Room Double 120 146 179
Standard Room Triple 161 193 237
Apartment Double 156 189 234
Apartment Triple 211 255 318
Maisonette Double 166 206 255
Maisonette Triple 227 278 345
Junior Suite Double 199 240 288
Junior Suite Triple 268 321 385