We have Microsoft Office XP. We have a custom program in Access that we can use to query a table and produce another table of just the results of the query.
After we have produced the results and have selected all its rows, we would like to copy and paste it into our Excel to use the results further. However, two irritable things happen when we do the paste of the Aceess table into Excel ...
1) We loose the columns widths of the Access table. The pasted data has whatever the Excel column widths were and not the ones in the Access table we copied.
2) Excel treats the number columns of the Access table as text instead of numbers, when it is pasted.
How can we paste and keep the Access column widths and preserve the Access numbers too?
(Note - We don't remember having this problem when we used Excel 97 and Access 97).
Any help would be appreciated.
Thanks
John
After we have produced the results and have selected all its rows, we would like to copy and paste it into our Excel to use the results further. However, two irritable things happen when we do the paste of the Aceess table into Excel ...
1) We loose the columns widths of the Access table. The pasted data has whatever the Excel column widths were and not the ones in the Access table we copied.
2) Excel treats the number columns of the Access table as text instead of numbers, when it is pasted.
How can we paste and keep the Access column widths and preserve the Access numbers too?
(Note - We don't remember having this problem when we used Excel 97 and Access 97).
Any help would be appreciated.
Thanks
John