| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I query my excel database.
Hey people, i'm in need of help!! I made a vba recordset code that imports
the whole access table into my excel worksheet. How the hell can I run a query in excel (I know Oracle, and I understand jack about MS Query, it really isn't SQL). I want that result of the query to be in another worksheet. Made it like this cause there's many queries I need to make (218) and excel will most likely freeze if it searches for queries in access (import data). |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I query my excel database.
Try this page Chay
http://www.rondebruin.nl/accessexcel.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Chay" wrote in message ... Hey people, i'm in need of help!! I made a vba recordset code that imports the whole access table into my excel worksheet. How the hell can I run a query in excel (I know Oracle, and I understand jack about MS Query, it really isn't SQL). I want that result of the query to be in another worksheet. Made it like this cause there's many queries I need to make (218) and excel will most likely freeze if it searches for queries in access (import data). |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can I query my excel database.
Thank you a zillion Ron de Bruin.
"Ron de Bruin" wrote: Try this page Chay http://www.rondebruin.nl/accessexcel.htm -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Chay" wrote in message ... Hey people, i'm in need of help!! I made a vba recordset code that imports the whole access table into my excel worksheet. How the hell can I run a query in excel (I know Oracle, and I understand jack about MS Query, it really isn't SQL). I want that result of the query to be in another worksheet. Made it like this cause there's many queries I need to make (218) and excel will most likely freeze if it searches for queries in access (import data). |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Edit query in excel 2000 | Excel Discussion (Misc queries) | |||
| pointing to the full list from a database query | Excel Discussion (Misc queries) | |||
| excel - access query - date range | Excel Discussion (Misc queries) | |||
| Excel 2000 required username and password login for database query | Setting up and Configuration of Excel | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Linear Mode
