Import Data from Excel to SQL

Hi,

I have to import data from an excel file to SQL 2008 R2. Please help me out on this. Kindly let me know from scratch.

Re: Import Data from Excel to SQL

try this

http://support.microsoft.com/kb/321686

http://www.codeproject.com/Articles/32581/Import-Data-from-Excel-to-SQL-Server

Re: Import Data from Excel to SQL

In sql, right click on your dataBase you will have an "import..." option. Than tou will have a wizard, follow it. In import section you will have source data options -

choose flat file source. that play with the field seperators and line delimiters...

It is quite easy.... If you succeeded to achieve it - check the box save it as ssis or something like that - that will keep the procedure you did manualy into an automatic job that you can active any time you want.

Hope I helped.

If there are any more questions let me know.

Re: Import Data from Excel to SQL

I need to upload the Excel data from .Net framework not from SQL

Re: Import Data from Excel to SQL

Hi,

Have a look at these samples about importing Excel data to Sql Server:

http://support.microsoft.com/kb/321686

http://www.codeproject.com/Articles/29045/Import-Excel-files-to-SQL-Server-dynamically

http://shawpnendu.blogspot.com/2009/05/how-to-import-excel-spreadsheet-data.html

Thanks,