Software

Ask something
Discussion Locked

Analyze it with MS Excel from MS Access

0 helpful
2 replies

by scminter 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

When I run a Microsoft Access report and then click on the menu icon "Analyze it with MS Excel" I import the data into Excel.

Every time I do this my next step is to always click Format -> Cells -> Alignment tab and then turn off "wrap text" by clearing the checkbox.

Is there any way to make this the default behavior when importing from Access?

2 replies

by misscrf

My only thought would be to do the import from Excel instead of Access. go to tools, data, get external data. One you get the db and the table or query you want ( which ever feeds the report) before clicking ok to do the import, set the import properties or specs. Then save the import specs for the data. After updating data in access over time, if you want to see it in excel again, just go to the excel document and refresh data. The specs will stay the same.

by scminter

That is not an option because the export is occurring from an Access application.

This discussion is closed to new replies.