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 |
|
Amethystium
Aged Yak Warrior
701 Posts |
 Posted - 2003-09-04 : 06:50:37
|
| Hello,I am trying to import some data from an .xls document to a SQL Server table. For some strange reason, some columns are being populated with NULLS even though there are other non NUL values existing. My feeling is that DTS assumes the column to be totally empty if the first row for that column is empty. How do you get around this problem?Thanks in advance.------------------------------------------------------------------------------I enjoy using SQL Server but I am not part of the Microsoft fanboy club! NEVER!! |
|
|
Stoad
Freaky Yak Linguist
1983 Posts |
Posted - 2003-09-04 : 07:30:12
|
| It is a weird trouble. Try:1. Active Script Task...Dim e'6 xlCSV, 21 xlTextDOS, 23 xlCSVWindows, 42 xlUnicodeTextSet e = CreateObject("Excel.Application")e.Visible = Falsee.DisplayAlerts = Falsee.Workbooks.Open "D:\my.xls"e.ActiveWorkbook.SaveAs "D:\my.txt", 21e.QuitSet e = Nothing2. Bulk Insert Task... |
 |
|
|
|
|
|
Strange DTS