Import and export sql data in microsoft excel file
-
Hi, I want to import data from sqlserver to excel file and export data from excel to sqlserver. I have imported the data from sqlserver but i don't have idea to export data from excel to sqlserver. Do you guys have any solution that can help me. Thanks Arslan Ilyas .Net Developer Red Signal
-
Hi, I want to import data from sqlserver to excel file and export data from excel to sqlserver. I have imported the data from sqlserver but i don't have idea to export data from excel to sqlserver. Do you guys have any solution that can help me. Thanks Arslan Ilyas .Net Developer Red Signal
Have you had a look at DTS (SQL Server 2000) or SSIS (Sql Server 2005). Do you have to do this from an ASP.net front end?
-
Hi, I want to import data from sqlserver to excel file and export data from excel to sqlserver. I have imported the data from sqlserver but i don't have idea to export data from excel to sqlserver. Do you guys have any solution that can help me. Thanks Arslan Ilyas .Net Developer Red Signal
You could also look at this post from today in the SQL forum: http://www.codeproject.com/script/Forums/View.aspx?fid=1725&msg=2356976[^]