Last post Oct 08, 2007 05:57 AM by vijayvrr_2001
Oct 08, 2007 05:28 AM|chathu03j|LINK
Hi I need to send some data records which are on a excel spreadsheet direclty(or through ASP.NET aplication) to the database in sql server. But the data may have to go to seperate tables. Is this possible? If so, how can I do that? Or else can Somebody
suggest a way to do that?
thanks in advance
Oct 08, 2007 05:57 AM|vijayvrr_2001|LINK
There are multiple ways of doing the requirement.
1. You can use DTS Import wizard.. It can also be programatically controlled.
2. You can also elegantly use a query to import the excel data in to SQL. The following link explains the same. Please note that the full page link explains certain preconditions required for the import operation.
Explanation of the OPENROWSET function that is used in the above link