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 |
|
detlion1643
Yak Posting Veteran
67 Posts |
 Posted - 2010-06-10 : 12:38:27
|
| Here is the link to the first part I had trouble with:[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=145793[/url]Now, that part is finally solved, but I ran into another problem. Column3 is causing trouble because the data is not always in integer format, it contains strings as well. The format in excel is left as general, but when the data gets put into sql - it's always put in as null. The datatype in sql is set to varchar(255) and the strings never go over 50 characters.It doesn't error out, so I can't really figure out why it's putting in null values instead of the actual data. |
|
|
|
|
|
openrowsets and datatypes prt.2