Error in using Export or Analyze With feature

N

NPDPallotti

Hi,

I'm trying to copy and paste information (one row from a database into one
Excel spreadsheet at a time, to be saved as unique spreadsheets of one row
each, which will be edited by external clients and then pasted back into an
Access database) from Access into Excel. Each time I try, data is missing.

I tried exporting the data from Access to Excel using File>Export as well as
Analyzing the data with Excel using Tools>Office Links>Anaylze it with Excel.
Each time, I get the same problem: the data in certain fields cuts off at
255 characters. In the original database, I have these fields set to Memo
rather than text to avoid the 255 cut-off.

Any ideas on why Access is cutting off the data when I try to put it into
Excel?

Thank you!

Stacie
 

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

Merging from an Excel file with graphics 1
Creating a Search using a combo box and then creating a report. 4
Export and Analyze With error 1
VBA concatenate ranges into a new document 0
Using Office Forms and dynamically updating the excel backend 0
Duplicate pst, or is it? 0
analyze data with excel feature in office 2007? 2
Autonumber field in Excel that behaves the same as Access 0

Top