Last post Mar 02, 2012 06:39 AM by Qin Dian Tang - MSFT
Feb 29, 2012 07:33 AM|abhinavsaxena|LINK
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.
Feb 29, 2012 07:37 AM|sunilgurjar|LINK
Feb 29, 2012 07:40 AM|duzi|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.
Feb 29, 2012 12:02 PM|abhinavsaxena|LINK
I need to upload the Excel data from .Net framework not from SQL
Mar 02, 2012 06:39 AM|Qin Dian Tang - MSFT|LINK
Have a look at these samples about importing Excel data to Sql Server: