View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Marcotte A Marcotte A is offline
external usenet poster
 
Posts: 66
Default 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.