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!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
BTrieve varchar being truncated in Access
Thanks for the quick response. I tried pulling the data into Excel using MS Query and ended up having the same problem as they had with Access. I also tried "substring(TABLENAME.FIELDNAME,110,120)" in MS Query to see if the data was available to the query but just not being displayed for some...- AndyBear
- Post #3
- Forum: Pervasive: Pervasive.SQL
-
BTrieve varchar being truncated in Access
I have a client who's trying to pull VarChar data out of a BTrieve database into Access, but the data is being truncated after 120 characters. The field size in Access is set to 250 characters, so that shouldn't be the problem. Is there something specific we should be looking at in the source...- AndyBear
- Thread
- Replies: 3
- Forum: Pervasive: Pervasive.SQL
