Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Paste into Excel from Access

Status
Not open for further replies.

JFF

Programmer
May 6, 2001
13
US
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
 
Why don't you just fire the query from within Excel?
(Use Data > Get External Data > Create New Query....foloow through with the wizard...it's pretty self-explanatory)
...eliminate some of the headaches you're causing with the cutting and pasting....
 
or you could use a macro in acces and export the query using transferspreadsheet. once you export it once, you can go into excel and adjust your column widths, they will stay the same after that.
i have run into the same problem when i paste my data into excel from access, but if i export it from access to excel everything is the way it is supposed to be.

hope that helps.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top