Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO to SQL - smalldatetime problem
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADO to SQL - smalldatetime problem
Please disregard question
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Colon at the end of excel file name(ex: problem.xls:1, problem.xls | New Users to Excel | |||
Started out as an Access problem. Now an Excel problem | Excel Discussion (Misc queries) | |||
problem with a conditional max problem | Excel Discussion (Misc queries) | |||
Problem when multipple users access shared xl-file at the same time, macrocode for solve this problem? | Excel Programming |