Upload Data into excel 2007

Question

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

kiril.lazarov.77 Hall of Fame Points: 3742 More actions · Answer 1

Is there a question here? have you tried the import export wizard?

Shaun2012 Hall of Fame Points: 3214 More actions · Answer 2

i tried but it does not allow to store as actual datatype but taking as unicode string..

Richard Warr SSCertifiable Points: 6966 More actions · Answer 3

Excel does not have as many data types as SQL Server so won't be able to store most of them without conversion.

This article shows how they are mapped.

kiril.lazarov.77 Hall of Fame Points: 3742 More actions · Answer 4

Shaun2012 (11/1/2013)
i tried but it does not allow to store as actual datatype but taking as unicode string..

save it as a SSIS package and try to change the column types in the excel destination properties.

SQL Severe DBA Hall of Fame Points: 3579 More actions · Answer 5

One more option you may choose is Importing the SQL data from Excel via data connection option . You can convert the query the way you want .

Shaun2012 Hall of Fame Points: 3214 More actions · Answer 6

i tried it worked now.. but i want to move the file to network in particular location ..

shaun