Analyse with Excel

M

MuJay

In Access 2000 when I used the Analyse with Excel button to export a report,
text fields are truncated (to 170 characters). How can i get round this
problem.
 
T

Tom van Stiphout

On Wed, 30 Jan 2008 07:51:03 -0800, MuJay

Have you tried:
DoCmd.TransferSpreadsheet

-Tom.
 

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

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Analyse with Excel not available in Access 2007? 2
Word to Excel: Export comments with text and line number 0
Fields in Checkboxes excluded in Analyse It with Microsoft Excel 2
Access to Excel 5
Conditions with a nested IIF 2
Stop truncate to 255 Chrs in Excel Export 5
Excel Data into Access Tabkes 1

Top