| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel database query from quickbooks
Has anyone attempted to create a query from quickbooks into Excel? I need
more detail on reporting than the canned reports in quickbooks and excel query may be the answer. If anyone has any thoughts, I would appreciate it. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel database query from quickbooks
"melissah" wrote: Has anyone attempted to create a query from quickbooks into Excel? I need more detail on reporting than the canned reports in quickbooks and excel query may be the answer. If anyone has any thoughts, I would appreciate it. I haven't queried the QB database, what I do is run Sales by Customer detail reports to export all the transaction lines for all invoices (based on date and Customer contraints). I export that report to Excel and create pivot table reports. After awhile, the data got to be too much to hold in Excel, so I exported it to an Access database, which I add to each week. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Edit query in excel 2000 | Excel Discussion (Misc queries) | |||
| Excel 2000 required username and password login for database query | Setting up and Configuration of Excel | |||
| Database Query -- Data Type Mismatch | Excel Discussion (Misc queries) | |||
| Use Excel to make an update query to another database table? | Excel Discussion (Misc queries) | |||
| How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) | |||
Linear Mode
