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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-04-28 : 14:11:58
|
| tbrown writes "Am importing from Excel to SQL table. Field has mostly numbers but some rows have the word "FLEX". The import is importing the numbers fine but is changing the word "FLEX" to nulls. The field (region) is defined as [Region] nvarchar (10) NULL on the import. The field is defined as general in Excel. Here is an example of the data in Excel:12121212FLEX1212The "flex" above is imported as a null value. I don't get it. Please help.tbrown" |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-04-28 : 17:31:11
|
| When you import the data, you have the option to define your columns by clickingon transformation. You will notice that because the first so many rows are numeric it's trying to import this field that way. You need to change it to a varchar field and your data will come across fine.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
problems with import