Excel table not being linked correctly

[pgemyk]

I have several linked excel tables. All of the tables have the exact same format. One of the tables is not being linked correctly. There are 58 columns in the table and Access is loading 255 and giving an error that it is only loading 255 fields.
I cannot see anything in the excel file to indicate anything beyond the 58 columns.

Any ideas?

Thanks

 

[SkipVought]

Hi,

Open the Excel file.

SELECT all columns to the right of the table.

Right-Click and select DELETE (do not use the DELETE key!)

SAVE & CLOSE.

 

[pgemyk]

Thanks Skip, but that is one of the first things that I tried.

 

[SkipVought]

Hmmmmm.

Then SELECT all cells on the worksheet.

COPY

Right-Click and SELECT Paste Special--VALUES