truncated data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm copying the results of a Access query into Excel. The data in one access
field is > than 255characters. All the data is present in the Access query,
however the paste into exce truncates the field. Any ideas?
 
Is the excel sheet you are pasting data to clean/new? If not, select all
excel cells and ensure you have no merged cells. Try this, hope this helps.
 
Here are a couple options:

1)Use <data><get external data><new database query> etc...to pull the data
into your workbook

OR
2)Export the MS Access query data to an Excel file.
Then, copy from THAT Excel file into your Excel file.

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 
I couldn't get the <data><external data><new database query> to work.
Probably my inexperience. The 2nd option also didn't work. A co-worker
suggested to copy the query into word then into excel. That worked!

Thanks,
 

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
Find truncated cells 1
No. of characters in an Excel column 2
Make Table Query Truncating Memo Field at 255 Characters 2
Truncate a data entry cell 3
Transferring data from MS Access to MS Excel 2
problem importing text into excel 2007 2
No Results returned from Access query 3

Back
Top