How do you determine or choose a data type for a linked excel field. I have bee using an excel spreadsheet with a number format in a particular column. I now want to have a text column, so I changed the format in Excel, but the entries in the linked Access table show "#Num". I've tried re-linking the table, editing the field in many different ways in the spreadsheet as well as countless other things, but have had no joy. When importing a file, you can specify the format of the new object with a specification (via the "Advanced" tab in the import wizard), but you can not do this with linking to excel spreadsheets.

I'd appreciate any suggestions!!