>>>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.
It looks like the UT doesn't handle close-paren + period in a hyperlink.
http://msdn2.microsoft.com/en-us/library/23cw517s(VS.80).aspx
http://msdn2.microsoft.com/en-us/library/microsoft.office.interop.excel(VS.80).aspx