PC Review


Reply
Thread Tools Rate Thread

Import from Access - text cut off for one field

 
 
=?Utf-8?B?TGVzbGll?=
Guest
Posts: n/a
 
      14th Mar 2006
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.
 
Reply With Quote
 
 
 
 
Bruce Sinclair
Guest
Posts: n/a
 
      15th Mar 2006
In article <1CD10F2E-3E95-4ABD-8B80-(E-Mail Removed)>, =?Utf-8?B?TGVzbGll?= <(E-Mail Removed)> wrote:
>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.


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)

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
import text field 20080704 (4th of july 2008) as date access 03 Jay H Microsoft Access External Data 3 9th Jul 2008 12:06 PM
import excel to Access has a problem with text field ABCBAC Microsoft Excel Worksheet Functions 0 11th Nov 2006 09:09 AM
Import Text AND Add Field?? =?Utf-8?B?Sm9obiBW?= Microsoft Access VBA Modules 2 22nd Jun 2006 10:20 PM
Import frm Excel access won't convert text into a lookup field. =?Utf-8?B?SklNVw==?= Microsoft Access External Data 2 21st Dec 2005 05:02 AM
Import Excel text field to Access date field djh Microsoft Access External Data 3 21st May 2004 05:20 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:50 PM.