truncated data

[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?

 

[Guest]

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.

 

[Guest]

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

 

[Guest]

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,