Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing Access Query
Is there vba code that I can use that will allow me to import queries from
access into a spreadsheet in excel? What I currently do is create a command button and assign it a macro which opens the appropriate query, but it does not let me choose from all my queries. Does anyone know why excel does not let you import all your queries? And if you do know why is there some way around it, maybe changing the query to meet the criteria needed to import. Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing Access Query
Can't you use the Data--Get external data command for what you're looking to
do? -- Brevity is the soul of wit. "HELP" wrote: Is there vba code that I can use that will allow me to import queries from access into a spreadsheet in excel? What I currently do is create a command button and assign it a macro which opens the appropriate query, but it does not let me choose from all my queries. Does anyone know why excel does not let you import all your queries? And if you do know why is there some way around it, maybe changing the query to meet the criteria needed to import. Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing Access Query
What exactly is that?
"Dave F" wrote: Can't you use the Data--Get external data command for what you're looking to do? -- Brevity is the soul of wit. "HELP" wrote: Is there vba code that I can use that will allow me to import queries from access into a spreadsheet in excel? What I currently do is create a command button and assign it a macro which opens the appropriate query, but it does not let me choose from all my queries. Does anyone know why excel does not let you import all your queries? And if you do know why is there some way around it, maybe changing the query to meet the criteria needed to import. Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Importing Access Query
I simply do an edit to select all records of the query result and copy and
paste them into a blank excel spreadsheet. /Sandy "HELP" wrote: Is there vba code that I can use that will allow me to import queries from access into a spreadsheet in excel? What I currently do is create a command button and assign it a macro which opens the appropriate query, but it does not let me choose from all my queries. Does anyone know why excel does not let you import all your queries? And if you do know why is there some way around it, maybe changing the query to meet the criteria needed to import. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing EXCEL Spreadsheets into ACCESS -- Macro or VBA? | Excel Discussion (Misc queries) | |||
Problems importing from an Access query | Excel Discussion (Misc queries) | |||
Importing result from Access query to Excel but the result only c. | Excel Discussion (Misc queries) | |||
Importing a table from Access query | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |