Import Excel into SQL Openrowset Connection RSS

• • Reply
  

  junjie1800

  Member

  18 Points

  59 Posts

  Import Excel into SQL Openrowset Connection

  Jul 23, 2009 01:55 AM|LINK

  Hi, could someone help me import excel into SQL using openrowset. I need it to be in oledb connection type of thing. 

  POOPLER.com
  • Moved by XIII on Jul 23, 2009 04:39 AM
• • Reply
  

  amit.jain

  Star

  11225 Points

  1815 Posts

  Re: Import Excel into SQL Openrowset Connection

  Jul 23, 2009 05:12 AM|LINK

  You can use SqlBulkCopy method
  

  Don't say thanks rather mark my reply as "Answer" if it helps you
  amiT jaiN
  
  ASP.NET C# VB Articles And Code Examples
  • Marked as answer by junjie1800 on Jul 27, 2009 03:25 AM