Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
xxMarkDxx
Starting Member
3 Posts |
 Posted - 2012-04-13 : 06:41:52
|
| I am using the Import and export wizard in sql 2008 to import a large Excel spreadsheet into a table , within the excel spreadsheet i have field named CustomerId some of the id's within the fields are all numbers and some are all letters . I have set the field Type NvarChar(50) but when i run the import it is only importing the Ids that are all numbners and it is leaving the fields Null for the ones that are all Letters , My question is what would be the best Field Type to hold all off the Ids ( i have tried using a text field tyoe and this is giving me the same results ) |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-13 : 11:13:16
|
| are you using query option or is it direct pull?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Using the Import and Export Wizard