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 |
|
Christophe
Starting Member
3 Posts |
 Posted - 2004-10-10 : 22:09:21
|
| Hi,I am struggling to import data from Excel To SQL Server7. With DTS package it works fine excepted that it inserts null values for a column. I have learned this is because the first 8 rows of my excel file are blank for this column .Do u know a workaround/Patch to fix this SQLServer bug?Thanks for your help,Chris |
|
|
Christophe
Starting Member
3 Posts |
Posted - 2004-10-12 : 16:18:30
|
| I actually have done a test with SQL Server 2000 by increasing the value of the registry key "TypeGuessRow". I thought it was limited to 16 but works fine with 50 (and probably more).I unfortunately have no access on our SQL Server7 and wonder if I also can increase "TypeGuessRow" on Windows2000/SQL Server7 environment.help would be great appreciated. Thanks, |
 |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2004-10-14 : 07:21:12
|
| As this relates to the JET OLEDB Provider, the version of SQL Server shouldn't be an issue. BTW you can set this to 0 to get it to check 16384 rows (although there may be a small performance hit).Mark |
|
|
|
|
|
|
Import from Excel: avoid null values