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.
abhinavsaxen...
Member
48 Points
41 Posts
Import Data from Excel to SQL
Feb 29, 2012 07:33 AM|LINK
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.
sunilgurjar
Contributor
2252 Points
478 Posts
Re: Import Data from Excel to SQL
Feb 29, 2012 07:37 AM|LINK
try this
http://support.microsoft.com/kb/321686
http://www.codeproject.com/Articles/32581/Import-Data-from-Excel-to-SQL-Server
read my blog
http://sunilgurjar.blogspot.com/
duzi
Member
355 Points
90 Posts
Re: Import Data from Excel to SQL
Feb 29, 2012 07:40 AM|LINK
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.
abhinavsaxen...
Member
48 Points
41 Posts
Re: Import Data from Excel to SQL
Feb 29, 2012 12:02 PM|LINK
I need to upload the Excel data from .Net framework not from SQL
Qin Dian Tan...
All-Star
113532 Points
12480 Posts
Microsoft
Re: Import Data from Excel to SQL
Mar 02, 2012 06:39 AM|LINK
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,
If you have any feedback about my replies, please contactmsdnmg@microsoft.com.
Microsoft One Code Framework