ADO to SQL - smalldatetime problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Excel 2002
MDAC 2.8
SQL Server 2000

I'm trying to test a stored prcedure by sending data to it from Excel.
There are three smalldatetime parameters that work fine if the Excel data is
formatted to display no time component. If the cell format includes the time
component, I get this error

-2147217833
Arithmetic overflow error converting expression to data type smalldatetime.

A little experimenting shows that ADO is sending the displayed value, not
the cell's actual value.

The table to which the stored procedure writes REQUIRES a time component for
2 of the columns, so I get a database error if the time portion isn't
included.

Anybody have any ideas how to push Excel data and time data into a
smalldatetime parameter?

Thanks
Duke
 

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

SmallDateTime 7
Changing smalldatetime to string 2
using smalldatetime to ONLY store date 1
conversation of char data type to smalldatetime 1
ADO with mixed data 2
How to assign a value to a sql 'smalldatetime' data? 1
ADO connection Open failure 5
MS Query - Parameter Bug 1

Back
Top