Is it possible Import & Export Excel Data to SQL Table using T-SQL query with formatted file

• Dipak-387207

  Mr or Mrs. 500

  Points: 566

  More actions

  March 21, 2008 at 11:04 am

  #120593

  Hello,

  I have one problem in SQL,

  I want to Import excel data to SQL table using Formated excel file

  or also export excel data to excel file using formated excel file using T-SQL.

  Please help

  Thanks

  Dipak

• Adam Bean

  One Orange Chip

  Points: 26631

  More actions

  March 21, 2008 at 11:38 am

  #792631

  Yes, use OPENROWSET.