Let's start from the beginning. Open MS Excel. Using the Data menu pulldown, Import External Data and select New Database Query...
Select Databases and QuickBooks Data :
Select the InvoiceLine table and the fields/columns as used by this example :
Enter the filter parameters for the TxnDate as shown :
Click Next to bypass Sort by (Order by) as you should always allow QODBC to sort how rows are returned whereever possible :
Click on View data or edit query in Microsoft Query and select [ Finish ]:
Replace the Critera value for TxnDate from:
>=#1/1/2006# And <=#1/1/2008#
To :
>=[Enter Start Date] And <=[Enter Finish Date]
Note: Due to Date, DateTime (used by MS Access) and Timestamp (used by MS Query) data types, when using MS Query you will also need to change the Critera Field from TxnDate (Date) to TimeCreated (Timestamp) :
Using the File menu pulldown, select Return Data to Microsoft Office Excel... :
You can select the cell where you want to put the data in your worksheet :
Now whenever you Refresh Data :
it will now prompt you to Enter Start Date :
Then Enter Finish Date :
See also: How do I use prompted date ranges in MS Access? |