Importing from excel problem

[SteveGr]

Hi all,
I have a linked table to an excel spreadsheet. Everything was fine until some of the data stopped linking. I have several columns and some of the data shows up in access and some of it doesn't.
The columns are formatted as "text" in excel.

Thanks, Stevegr

 

[pdx_man]

The format the data has in Excel doesn't mean a pile of beans to Access. What matters is the content. Especially the first row of data (after the headings if you have them). If in the first row you have a number, 5465, and then in the next you have text, 5F8D, you are going to have a problem importing. (Create a dummy row in the first row that contains the data types that is typical of the entire recordset, then delete it in Access) If your headings have any periods (dot), you will have a problem importing. If you have blank rows and/or blank columns, you have problems importing. Again, format doesn't mean anything ...