Linking table to Excel spreadsheet

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?
 
N

Nikos Yannacopoulos

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Access to Excel link 2
Changing field definition in Linked Excel Table 2
Linked Excel spreadsheet to be used as table 3
Excel Access - importing an excel spreadsheet 0
Data Type Issue in Linked Excel Table 7
linking to an Excel spreadsheet 1
Linking a Table in Access with 365 Data Fields 3

Top