Data import error #1424
Unanswered
sergendula
asked this question in
Q&A
Replies: 1 comment
-
|
It seems actually an issue with datatype that is being uploaded to table. We can always get from datatype of lower precision to higher precision but the other way round it won't be valid. |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
I have tried importing data into my SSMS through python and for a start I successfully connect to the database and a table is being created but I keep getting the below error.
I initially thought its a problem with the data type but when I used a different excel file which I had uploaded manually on SSMS it still gave thesame error.
An error occurred: (42000',
'[42000] [Microsoft][ODBC Driver 17 for SQL Server] [SQL Server] The incoming tabular data stream
(TDS) remote procedure call (RPC)
protocol stream is incorrect.
Parameter 16 ("'"): The supplied value is not a valid instance of data type float. Check the source data for invalid values. An example of an invalid value is data of numeric type with scale greater than precision. (8023)
(SQLExecDirectW)')
09:42
Beta Was this translation helpful? Give feedback.
All reactions