Linked Table Missing a Column!

[Guest]

This is really weird and this is the first time that it has happened to me.

I have a linked excel table in the database with 10 columns. The last
column's name is 'Price'. It is a very simple table and it used to work
perfectly. Now when I open the table in access, I dont' see data in the
column 'Price'. it just gives me a blank column. I tried to relink it and
it looks fine when it goes through the process of asking me if the first row
is a column name row and the like but lo and behold, the data in the last
column disappears after that. I tried moving the columns so 'Price' is now
column 1 and found that it seems to follow that specific column (Price).

Any ideas? Any help will be greatly appreciated!

Thanks!

 

[Guest]

1. Make sure that the Price column isn't hidden in either the database or
spreadsheet.

2. Rename Price to something like Prices then delete the link and create a
newer one. I've seen stranger stuff.

3. Create a new spreadsheet and import everything into it. Link to the new
spreadsheet.

4. For testing purposes create a new database and link the the spreadsheet.
Does it work there? If so your original database could be corrupt.

 

[Guest]

Thanks Jerry. Putting the data in a new spreadsheet solved the issue! Who
would have thought!