Import from Access - text cut off for one field

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

Guest

I'm trying to analyze my query with excel.

One column shows incomplete data. It is correct in the query results but
cuts if off after I export.
 
I'm trying to analyze my query with excel.

One column shows incomplete data. It is correct in the query results but
cuts if off after I export.
Click to expand...

Is it a really long field ? IIRC, XL has a 256 character limit for each
cell.


Bruce

----------------------------------------
I believe you find life such a problem because you think there are the good
people and the bad people. You're wrong, of course. There are, always and
only, the bad people, but some of them are on opposite sides.

Lord Vetinari in Guards ! Guards ! - Terry Pratchett

Caution ===== followups may have been changed to relevant groups
(if there were any)
 
You must log in or register to reply here.

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

Cutting off data in a cell 3
Query to text file cuts my leading zeros off. 4
Access #Error & Excel Pivot 0
Memo Field cut off in query 4
Exporting from Access to text 2
Moving a bunch of data 1
Import data from Access to Excel containing VB code 3
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Back
Top