I am in trial mode and this was my first query into excel, i was copying the steps from your excel video tutorial.

Try disabling (unchecking) the "Use Case Sensative RefNumber Searches" option. Use Case Sensitive RefNumber Searches when checked means a refnumber of 'ABC' and 'abc' will be different and QuickBooks will use an index internally for a search instead of a complete table scan. (Note: this feature applies to versions of QuickBooks 2005 and higher).

unched and re ran, but still same error.

without Excel open i can use VB demo 32 to do the default comapny name no problem.

But when i open excel/ data/import external data/newDataBaseQuery i still get the error 1000, same error whether returning data to excel or MS Query.

ok,  was able to import some data into excel, what does that mean?

As i don't know what is different with that query.

CD

how do i do that?

You can also specify the OpenMode setting in your connection string. See: How do I build a connection string with all the available QODBC parameters? for more.