Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exporting data to Excel pivot table from Access
Hello,
Is there a way to take the results of a select query in an Access database and export those records to the 'Source' tab of an Excel spreadsheet, and thus over-write the data that was there to provide 'refreshed' data for the Pivot Table? I'd like to put this code behind a command button in my Access application. Is this possible? -- Thank you, Patrick |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exporting data to Excel pivot table from Access
Hi Pat,
Try: (this is n Excel 2003) 1. Select Data 2. Select External Data 3. Select Import Data 4. In the "Select Data Source" dialog box navigate to the source Access database and select it. 5. Select your query from the ""Select Tables" dialog box. You will then be asked where you want your data to reside. My guess is that you wll be able to record these keystrokes as a macro and then assign it ot a macro. HTH John. "Pat Dools" wrote: Hello, Is there a way to take the results of a select query in an Access database and export those records to the 'Source' tab of an Excel spreadsheet, and thus over-write the data that was there to provide 'refreshed' data for the Pivot Table? I'd like to put this code behind a command button in my Access application. Is this possible? -- Thank you, Patrick |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exporting data to Excel pivot table from Access
Excuse me! I meant assign the macro to an object.
John "JCS" wrote: Hi Pat, Try: (this is n Excel 2003) 1. Select Data 2. Select External Data 3. Select Import Data 4. In the "Select Data Source" dialog box navigate to the source Access database and select it. 5. Select your query from the ""Select Tables" dialog box. You will then be asked where you want your data to reside. My guess is that you wll be able to record these keystrokes as a macro and then assign it ot a macro. HTH John. "Pat Dools" wrote: Hello, Is there a way to take the results of a select query in an Access database and export those records to the 'Source' tab of an Excel spreadsheet, and thus over-write the data that was there to provide 'refreshed' data for the Pivot Table? I'd like to put this code behind a command button in my Access application. Is this possible? -- Thank you, Patrick |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Exporting data to Excel pivot table from Access
In Access, you would:
Create a new macro Select OpenQuery in one Action line. Fill in the text boxes at bottom of macro for this action. Select TransferSpreadsheet on the second action line of your macro. Fill in the text boxes at bottom of macro for this action. The text boxes are self-explanatory. HTH, John "Pat Dools" wrote: Hello, Is there a way to take the results of a select query in an Access database and export those records to the 'Source' tab of an Excel spreadsheet, and thus over-write the data that was there to provide 'refreshed' data for the Pivot Table? I'd like to put this code behind a command button in my Access application. Is this possible? -- Thank you, Patrick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Pivot Table connected to an Access Database Data Source | Excel Discussion (Misc queries) | |||
Access Create Excel Pivot Table Data Source | Excel Discussion (Misc queries) | |||
exporting data from access to excel | Excel Discussion (Misc queries) | |||
Exporting data from access to excel | Excel Worksheet Functions | |||
exporting summary data for pivot table! | Excel Worksheet Functions |