>>Hi,
>>
>>I need to write a .NET program to transfer a Excel spreadsheet into SQL Server. I need to open the spreadsheet a user specifies, do some simple processing and upload the sheet into a SQL Server table.
>>
>>I need suggestions, pointers to articles and samples. thank you.
>>
>>Chen
>
>Chen,
>
>Check out Visual Studio Tools for Office at
http://msdn2.microsoft.com/en-us/library/23cw517s(VS.80).aspx, and specifically the Excel tools:
http://msdn2.microsoft.com/en-us/library/microsoft.office.interop.excel(VS.80).aspx.
>
>But it seems like you might be better served by importing the spreadsheet into SQL Server first, then performing the simple processing either through .NET or with a stored procedure in SQL Server. The process will be much simpler this way.
Keith,
Thank you! However, your html links are not working correctly. But I did find interesting readings on MSDN.
Since I am comfortable with SQL Server, your suggestion of doing processing on the server is right on.
Chen Nan