Text being truncated

  • Thread starter Thread starter Trisha
  • Start date Start date
T

Trisha

I don't know if this should be posted in here or with
Access because I'm not sure which application is causing
my problem, but I'll start here.

Someone within our company has an Excel spreadsheet that
contains comments in one column. They import this
information to Access to run some queries and then exports
it back to Excel (I don't know why they do the
import/export), anyways, once they export it back to
Excel, some of the comments are truncated. Is there a
limit that Excel will accept or maybe Access can only
export a limited amount of characters.

I didn't know where to start to get him the answer, so I'm
hoping someone can at least point me in the right
direction.

Thanks for your help,
Trisha
 
Trisha,

Rather than just plough on with the problem, why don't you ask why it is
exported to Access then imported back to Excel. The best solution will
always benefit from knowing all of the requirements.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top