Converting Float to String

Question

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 .

How are mysql and sql-server both tagged in this question? — BlargleMonster
– BlargleMonster, Commented Jun 27, 2013 at 17:24
import wizard allows for variable changes to import values under the edit mappings button and you can map columns to new types — David Scott
– David Scott, Commented Jun 27, 2013 at 17:29
@DavidScott - make this an answer so the OP can give you credit for the answer. — Karl Anderson
– Karl Anderson, Commented Jun 27, 2013 at 17:41

David Scott · Accepted Answer · 2013-06-27 17:44:26Z

1

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

answered Jun 27, 2013 at 17:44

David Scott

1,1149 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Converting Float to String

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related