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.
--
Please post all your inquiries on this community so we can all benefit -
Thank you!


"amiramom" wrote:

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?

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


"amiramom" wrote:

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?

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,


"Ron Coderre" wrote:

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


"amiramom" wrote:

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?