I can't enter a date in a query

B

BHE

MS Query from within Excel (Data - Import External Data)

Under Data - Import External Data I am using MS Query to
return data to Excel from a database.
The query prompts the user for 2 dates (start and end) and
performs the query successfully.

I enter 6/1/2003 and 8/27/2003

SELECT * FROM x WHERE
(last_modify_time >= ? AND
last_modify_time <= ? )


*BUT* when I try to Return Data to Microsoft Excel I get
the following error:

[INTERSOLV][ODBC SQL Server driver]Inconsistent descriptor
information.

What do I have to do to get query to save?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Switching ODBC sources in Excel 2007 1
Ms query and Excel 0
Weird behaviour when entering hyperlinks 0
MS Query will not start from Excel 2000 8
entering parameter criteria MS Query 0
Import Data from Access query 8
Import External Data 3

Top