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!
Error pasting from Access to Excel
- Thread starter jkonline2
- Start date
You would not need to copy and paste the data to excel, (too many steps)...
Create a live link to the table or query from within excel,
From excel click Data>Get External Data>New Database Query>....the choose msaccess databases* from the list...follow the wizard from there (to select your mdb, table or query)
then return your data to excel.
You can opt to use the wizard or MsQuery (a gui type interface, similar to access)at this point...
after your comfy with this...I would recommend the MsQuery option.
when data is returned,...you can right click in the data and select properties to refresh on open...auto fill formulas etc.
this is now a live link, any time the workbook is opened. your current / up to date access data comes in (if you set the refresh on open option)
Create a live link to the table or query from within excel,
From excel click Data>Get External Data>New Database Query>....the choose msaccess databases* from the list...follow the wizard from there (to select your mdb, table or query)
then return your data to excel.
You can opt to use the wizard or MsQuery (a gui type interface, similar to access)at this point...
after your comfy with this...I would recommend the MsQuery option.
when data is returned,...you can right click in the data and select properties to refresh on open...auto fill formulas etc.
this is now a live link, any time the workbook is opened. your current / up to date access data comes in (if you set the refresh on open option)
- Status