Using QB 2008 Prem and QODBC V9

I found script "How do I use prompted date ranges in MS Excel?" on your support web-site. Following it i pulled my SalesLine data for a given date range into Excel without any problems. Next I added the Item table as i want to filter the sales data by certain item types, plus I would like to get some additional item fields into Excel.

When trying to link the SalesLineItemRefListID to Item.ListID I get an error popup titled Microsoft Query. The popup only says Error. I have an OK and Help button. The help button only shows a blank help screen. Clicking OK looses the link between the 2 tables.

Is there something missing for MS Query that I need to install?

This is MS Query playing up, I just did:

SELECT SalesLine.TxnID, SalesLine.TimeCreated, SalesLine.TimeModified, SalesLine.EditSequence, SalesLine.TxnNumber, SalesLine.CustomerRefListID, SalesLine.CustomerRefFullName, SalesLine.ClassRefListID, SalesLine.ClassRefFullName, SalesLine.ARAccountRefListID, SalesLine.ARAccountRefFullName, SalesLine.TxnDate, SalesLine.TxnDateMacro, SalesLine.RefNumber, SalesLine.BillAddressAddr1, SalesLine.BillAddressAddr2, SalesLine.BillAddressAddr3, SalesLine.BillAddressAddr4, SalesLine.BillAddressAddr5, SalesLine.BillAddressCity, SalesLine.BillAddressState, SalesLine.BillAddressPostalCode, SalesLine.BillAddressCountry, SalesLine.BillAddressNote, SalesLine.ShipAddressAddr1, SalesLine.ShipAddressAddr2, SalesLine.ShipAddressAddr3, SalesLine.ShipAddressAddr4, SalesLine.ShipAddressAddr5, SalesLine.ShipAddressCity, SalesLine.ShipAddressState, SalesLine.ShipAddressPostalCode, SalesLine.ShipAddressCountry, SalesLine.ShipAddressNote, SalesLine.IsPending, SalesLine.CheckNumber, SalesLine.PaymentMethodRefListID, SalesLine.PaymentMethodRefFullName, SalesLine.IsFinanceCharge, SalesLine.PONumber, SalesLine.TermsRefListID, SalesLine.TermsRefFullName, SalesLine.DueDate, SalesLine.SalesRepRefListID, SalesLine.SalesRepRefFullName, SalesLine.FOB, SalesLine.ShipDate, SalesLine.ShipMethodRefListID, SalesLine.ShipMethodRefFullName, SalesLine.Subtotal, SalesLine.ItemSalesTaxRefListID, SalesLine.ItemSalesTaxRefFullName, SalesLine.SalesTaxPercentage, SalesLine.SalesTaxTotal, SalesLine.Amount, SalesLine.Remaining, SalesLine.Memo, SalesLine.IsPaid, SalesLine.CustomerMsgRefListID, SalesLine.CustomerMsgRefFullName, SalesLine.IsToBePrinted, SalesLine.IsToBeEmailed, SalesLine.CustomerSalesTaxCodeRefListID, SalesLine.CustomerSalesTaxCodeRefFullName, SalesLine.SuggestedDiscountAmount, SalesLine.SuggestedDiscountDate, SalesLine.DepositToAccountRefListID, SalesLine.DepositToAccountRefFullName, SalesLine.CreditMemoLineGroupIsPrintItemsInGroup, SalesLine.Type, SalesLine.SalesLineType, SalesLine.SalesLineSeqNo, SalesLine.SalesLineGroupTxnLineID, SalesLine.SalesLineGroupItemGroupRefListID, SalesLine.SalesLineGroupItemGroupRefFullName, SalesLine.SalesLineGroupDesc, SalesLine.SalesLineGroupQuantity, SalesLine.SalesLineGroupIsPrintItemsInGroup, SalesLine.SalesLineGroupTotalAmount, SalesLine.SalesLineGroupSeqNo, SalesLine.SalesLineTxnLineID, SalesLine.SalesLineItemRefListID, SalesLine.SalesLineItemRefFullName, SalesLine.SalesLineDesc, SalesLine.SalesLineQuantity, SalesLine.SalesLineRate, SalesLine.SalesLineRatePercent, SalesLine.SalesLineClassRefListID, SalesLine.SalesLineClassRefFullName, SalesLine.SalesLineAmount, SalesLine.SalesLineServiceDate, SalesLine.SalesLineSalesTaxCodeRefListID, SalesLine.SalesLineSalesTaxCodeRefFullName, SalesLine.FQPrimaryKey, SalesLine.FQTxnLinkKey, SalesLine.CustomFieldBDay, SalesLine.CustomFieldContract, SalesLine.CustomFieldSpousesName, Item.ListID, Item.TimeCreated, Item.TimeModified, Item.EditSequence, Item.Name, Item.FullName, Item.Description, Item.IsActive, Item.ParentRefListID, Item.ParentRefFullName, Item.Sublevel, Item.Type, Item.SalesTaxCodeRefListID, Item.SalesTaxCodeRefFullName, Item.SalesOrPurchaseDesc, Item.SalesOrPurchasePrice, Item.SalesOrPurchasePricePercent, Item.SalesOrPurchaseAccountRefListID, Item.SalesOrPurchaseAccountRefFullName, Item.SalesAndPurchaseSalesDesc, Item.SalesAndPurchaseSalesPrice, Item.SalesAndPurchaseIncomeAccountRefListID, Item.SalesAndPurchaseIncomeAccountRefFullName, Item.SalesAndPurchasePurchaseDesc, Item.SalesAndPurchasePurchaseCost, Item.SalesAndPurchaseExpenseAccountRefListID, Item.SalesAndPurchaseExpenseAccountRefFullName, Item.SalesAndPurchasePrefVendorRefListID, Item.SalesAndPurchasePrefVendorRefFullName, Item.SalesDesc, Item.SalesPrice, Item.IncomeAccountRefListID, Item.IncomeAccountRefFullName, Item.PurchaseDesc, Item.PurchaseCost, Item.COGSAccountRefListID, Item.COGSAccountRefFullName, Item.PrefVendorRefListID, Item.PrefVendorRefFullName, Item.AssetAccountRefListID, Item.AssetAccountRefFullName, Item.ReorderBuildPoint, Item.InventoryDate, Item.DepositToAccountRefListID, Item.DepositToAccountRefFullName, Item.PaymentMethodRefListID, Item.PaymentMethodRefFullName, Item.TaxRate, Item.TaxVendorRefListID, Item.TaxVendorRefFullName, Item.CustomFieldColor, Item.CustomFieldMaterial, SalesLine.TxnDate
FROM Item Item, SalesLine SalesLine
WHERE SalesLine.SalesLineItemRefListID = Item.ListID AND ((SalesLine.TxnDate>={d '2006-01-01'} And SalesLine.TxnDate<={d '2008-01-01'}))

Try building the query manually.