SSMS forced data conversion type

by Dan Zainal   Last Updated October 10, 2019 04:06 AM

I am currently working on a project that requires data to be downloaded and saved to SQL server 2017. After the data has been downloaded, I used the SQL SERVER 2017 import and export program to export the data to excel .xlxs format. In the export wizard, I specified an INT datatype to be exported as a Long data type. After exporting the data, I found that the value is saved as a string rather than an Integer. If I want the data to remain as an INT even after exporting, what should be the appropriate data type that should have been selected during the export process?

Tags : ssms


Related Questions


Updated June 27, 2019 21:06 PM

Updated October 26, 2017 22:06 PM

Updated June 20, 2019 15:06 PM

Updated May 20, 2019 19:06 PM