Error in importing Database
hiogh said 1 year, 1 month ago:
I’m Using CSV Files to import data When I tried to import data with DateTime data type this error has shown up:
Error importing data from data_export.csv.
Imported 6 rows.
Errors:
The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value. The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value. The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value. The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value. The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value. The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value. The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value. The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value. The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value. The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value. The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value. Changed database context to ‘hioghwebsite’. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated. The statement has been terminated.
sherrod said 1 year, 1 month ago:
@hiogh,
I understand you are trying to import a csv file to your Database. The steps to accomplishing this may be found in:
Importing CSV Files into MS SQL Server Databases
If you continue to have issues you may wish to contact our Support team as they would be able to review the Hosting Account and Database in question.
Sherrod
0 min expected wait time