Monday, March 12, 2012

Save excel records into SQlserver

anybody give example code for save Excel records into sqlserver in asp.net1.1

Thanks

Do you must have this done in ASP .NET 1.1 code? SQL Server its self has some features to import data from EXCEL, for example Import/Export Wizard, DTS, bcp utility, etc. The most straight way is using Import/Export Wizard in Enterprise Manager (or Management Studio for SQL2005).

You can take look at this KB:

http://support.microsoft.com/default.aspx?scid=kb;en-us;321686

No comments:

Post a Comment