I have a preformatted Access table that suits my worksheet data.
Using the TransferSpreadsheet method I copy all the worksheet's
data into a copy of that table (named as the worksheet.name).

The last column refuses to import, and I don't know why. The
last col has a text value in row 1 (the Access Field Name), whilst
the rest of the column has either empty cells or numeric values.
Other columns with similar data and same Access Field setups
import fine. There are no formulae in the sheet.

I've tried different sheets and workbooks (all with the same basic
structure/formats/data types) and get the same result every time.

Any ideas, please?

Regards.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.674 / Virus Database: 436 - Release Date: 02/05/2004