RE: Excel to SQL Server column format issues
From: HWUK (HWUK_at_discussions.microsoft.com)
Date: 12/15/04
- Next message: aaronaw2k: "Sending 'print' output to dts log"
- Previous message: Magnus: "Return Code from Execute Process Task"
- In reply to: markd_at_magenic.com: "Excel to SQL Server column format issues"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 15 Dec 2004 03:23:03 -0800
Never known DTS to have a problem with spreadsheets before, NOT
Heres the reason -
http://www.sqldts.com/default.aspx?6,222,254,0,1
there is also a different way using OPENROWSET in a sql task that isn't
covered here but not sure how your currently importing and wether the
OPENROWSET works with named sets.
- Next message: aaronaw2k: "Sending 'print' output to dts log"
- Previous message: Magnus: "Return Code from Execute Process Task"
- In reply to: markd_at_magenic.com: "Excel to SQL Server column format issues"
- Messages sorted by: [ date ] [ thread ]
