{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Tech.Note.Analyze - in the Access table If you change or...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
The operation “analyze” Frequently the work book will instruct you to “analyze” a table in Excel. My sense of this operation is that it is the equivalent of a copy and paste. For a table or query, you would simply execute the query and then, while the “table” is in front of you, select the rows and columns that you want in Excel and move to the other application and do a paste into and empty worksheet. Note that this is a copy of the data
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: in the Access table. If you change or update the Access data, you would have to make corresponding changes in Excel. See Technical Note #1 for a method of linking the two together. I have located the following information in the help files for Access where the “analyze” operation is mentioned....
View Full Document

{[ snackBarMessage ]}