I am running a query in Excel that I want to prompt the user to enter in a date range. I am using the "between" value. Everytime I enter in a date, it errors and says "SQL data type out of range".

Connect to the database We tried this using MS-SQL 2000 Server for the database and Excel from MS Office XP. To query the database, start Excel, go to the Tools menu and click on Add-Ins.