Importing Excel Spreadsheets into Access

[DoniFromMars]

Problem:
Importing a spreadsheet (get external data..)

If "First Row contains column headings" is NOT checked
the import works fine

If "First Row contains column headings" IS checked I get the collumn headings and an empty table.

Any ideas?

 

[DrSimon]

Odd! I've had strange problems with spreadsheet import but not that.
Do you get an error report table after the empty table import?
Unless it's confidential or enormous, can you post the 1st two rows of the spreadsheet (i.e. header plus next row)?
Simon Rouse

 

[DoniFromMars]

Hi
Thanks. There was import error table.
Heres a bit of the xls in question.

 

[DoniFromMars]

Sorry! I meant that there was NO import error table.

 

[DrSimon]

That attach didn't work - try just pasting rows in.