How do you delete fields from a linked Excel table in access?

[Guest]

I am trying to create a report from a linked table in access. It links
perfectly. However, when I try to create a report. It says I have too many
field in my table. I have gone back to the excel table and deleted fields and
relinked under another name. I get the same result. Can someone help me
with this?

 

[Guest]

Hi.

However, when I try to create a report. It says I have too many
field in my table.

If any one record in the report's record source exceeds 2,000 characters,
then you'll receive the "too many fields" error message, even though there
are fewer than the maximum 255 fields in the table and the report. You'll
need to break it down into more manageable chunks, so that the report can
handle it. Use a query as the record source, not the entire table, and only
select the fields whose number of characters summed together do not exceed
the 2,000 character limit for any record.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

- - -
When you see correct answers to your question posted in Microsoft's Online
Community, please sign in to the Community and mark these posts as "Answers,"
so that all may benefit by filtering on "Answered questions" and quickly
finding the right answers to similar questions. (Only "Answers" have green
check-marks.) Remember that the best answers are often given to those who
have a history of rewarding the contributors who have taken the time to
answer questions correctly.