Linking table to Excel spreadsheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've linked an Access table to an Excel spreadsheet. The Excel spreadsheet
contains 5 columns. When I open up the Access linked table, it has 256
columns. 251 of the columns are blank. Since there is a 255 column limit in
access, when I run my query I get the following error: To many field
defined. Any ideas why this happens?
 
The problem is in the Excel file, there are probably some rubbish inn
the re which you don't see (but Access does). Open the spreadsheet in
Excel, select all the (supposedly) blank columns from 6 on to the last
one, right-click and Delete (not Clear Contents!), then save. Problem
solved.

HTH,
Nikos
 
Back
Top