I have linked an excel spreadsheet as a table in Access. All the cells in Excel are formated as a number with two decimal places, but when I link the table and display it in Access a lot of the numbers say #NUM. When I look at the design in Access - it it showin these records as text, and yet I had thm all set as nummbers before linking.

Any Ideas?

Thanks

Jet doesn't use the spreadsheet column data type because that is not always set, nor is it always indigative of what the data type actually is. Therefore, Jet analyzes the first few dozen rows in a spreadsheet to determine what data type to make the columns. There must be data in the spreadsheet that is text. For example, something as stupid as a blank row between the column headers and the start of the data will cause all columns to be text.

My spreadsheet has text headings and column A is also text. All other cells are numbers. I moved column A to be the last column in the spreadsheet. I can't get the table to link to Access and read all numbers as numbers. Access will not let me change the text to numbers in the design view of the linked table. It always seems to be the same cells that come in each time as #NUM! This is not one specific column or row, just sporadically across the data there are 30-40 cells that say #NUM! Is there a possible resolution for this?

Thanks
Terry

I'll bet if you examined the cells in the spreadsheet, you would find that the ones that Access is having difficulty with are actually text. Make sure that the cells don't start with a quote.