Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Inputting to Pivot Table - Error message "String data, right truncated

Status
Not open for further replies.
Robert1

Robert1

Technical User
May 19, 2000
8
0
0
GB
Whilst importing to an excel pivot table from an Access97 database I keep getting message &quot;String data, right truncated on column number1 (TABLE_CAT)&quot;<br><br>A copy of same database (one month old) works fine.<br>There is a table called &quot;Category&quot;, but comparisons between old copy and current version appear identincal in all ways.
 
Sort by date Sort by votes
Have you found a solution for this 'String Data, right truncated on column number 1 (TABLE_CAT)' error? I am experiencing the same error when trying to use MS Query in Excel to get external data from Access.
 
Upvote 0 Downvote
Me too... surely someone knows how to fix this... please help if you can. thanks
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

OCM
  • Question
Populate access table from excel
Replies
6
Views
424
OCM
OCM
TheresAlwaysAWay
  • Locked
  • Question
Can Access be used to generate and respond to text messages? 1
Replies
6
Views
377
TheresAlwaysAWay
TheresAlwaysAWay
PizMac
  • Locked
  • Question
error 3027 database or object is read-only
Replies
5
Views
201
PizMac
PizMac
MikeRei
  • Locked
  • Question
Help taking horizontal data and displaying it vertically (continuously)
2
Replies
27
Views
563
dhookom
dhookom
atadbitslow
  • Locked
  • Question
how to search data and display matches that include the user's input, but not necessarily match
Replies
5
Views
187
atadbitslow
atadbitslow

Part and Inventory Search

Sponsor

Back
Top