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?