I am importing data from an excel worksheet in to a sql table,
one of the columns in the table is set to nvarchar(50), the data i am importing are barcodes, but the problem i am having is the column is changing the data
for example the number "5900397732209" is converted to "5.9004e+012" this is only happening when the data is imported.
if i save the barcode direct from my software it shows in the correct format in the table.
anyone know why this is.
riayas
0
Newbie Poster
Recommended Answers
Jump to PostExcel is formatting the number. Open excel and set the desired format for those columns.
First select the column:
Next set the formatting:
Click okay and you are finished!
All 4 Replies
Begginnerdev
256
Junior Poster
riayas
0
Newbie Poster
Begginnerdev
256
Junior Poster
riayas
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.