Exporting a report to Excel

  • Thread starter Thread starter Raj
  • Start date Start date
R

Raj

Dear All,

I have an access report exported to a excel spreadsheet. Everything works
fine, but the content data gets restricted somewhere. For eg., I have a
comment field with datatype memo in access, if i export to excel am not
getting the full data exported. I am not sure where am doing wrong.

I would appreciate any help.

Thanks folks..
-Raj.
 
Hi,


If you pass through some more or less complex query, your memo may be
truncated to 255 char, to fit in a varchar field (or text field, like Jet
call them),


Hoping it may help,
Vanderghast, Access MVP
 

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

Exporting a report to Excel... 4
Export to excel has character limit 3
exporting a queried form to Excel 5
export access report into excel 3
Exporting Memo fields into Excel 1
Export to Ascii 1
Help exporting URL format to Excel from Access Query 1
Filtering a Query then Exporting to Excel using VB 1

Back
Top