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 |
|
werhardt
Constraint Violating Yak Guru
270 Posts |
 Posted - 2008-10-28 : 12:11:46
|
| I have to import an excel file into SQL. The one column is not importing all the records into the table. If there is a number and letter in that colunn, it is putting it as null example (06A). The field setting when it comes over into the SQL table is (Floating, Null). I tried creating the table and then changing the field setting and it is still now working. What other suggestions can you give me, if you can. Thanks! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-10-28 : 12:13:22
|
| try after making field varchar. how are you exporting data? using export/import wizard or OPENROWSET? |
 |
|
|
werhardt
Constraint Violating Yak Guru
270 Posts |
Posted - 2008-10-28 : 12:23:26
|
Actually I figured it out. When you try to Import an excel file it is not working, but when I take the file and place it in Access then Import it into SQL it works. Not sure why but it did.quote:
Originally posted by visakh16
try after making field varchar. how are you exporting data? using export/import wizard or OPENROWSET?
|
|
|
|
|
|
|
Importing Excel Into SQL Table