CODEWITHSUNDEEP
c#asp.netmysqlsql-server
user2511109
user2511109

Reputation:

Converting Float to String

I am importing an Excel sheet to SQL, and it is getting stored in table1. I am then copying the data from table1 to table2 with the below query:

insert into table1(JOB_ID ,JOB_NAME)
select isnull(JOB_ID,'') ,isnull(JOB_NAME,'') from table2$

But my requirement is, when it's getting imported from Excel to SQL table the datatype of JOB_ID is automatically gone to Float.So when am copying that data into another table the values in table2-JOB_ID are in float.but i need it in string or varchar .

Upvotes: 0

Views: 186

Answers (1)

David Scott
David Scott

Reputation: 1084

import wizard allows for variable changes to import values under the edit mappings button and you can map columns to new types

Hope this helps

Upvotes: 1

Related Questions