1

I am using OS Windows 7 and Office 2010 and SQL Server 2008/2008R2/2012. I am trying to import excel sheet to SQL Server. One column has several Numeric and Text values as well. While importing data from excel, numeric values are not getting imported. First row of excel sheet has headers. Many of the blogs have suggested to update IMEX=1. But I could not find how and where IMEX value has to be set to 1. Please help

Erik A
  • 31,639
  • 12
  • 42
  • 67
Shiva
  • 432
  • 8
  • 20

1 Answers1

1

try this pattern:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\myFolder\myExcelFile.xlsx;
Extended Properties="Excel 12.0 Xml;HDR=YES;IMEX=1";

Update

For your additional question, please refer to this thread:

https://stackoverflow.com/a/376017/1057667

It's already answered here I think.

Community
  • 1
  • 1
Sunny Sharma
  • 4,688
  • 5
  • 35
  • 73
  • 1
    Thanks. This works when I use Local instance of SQL Server as the excel file is in my local system. How to import excel which is in my local system and SQL Server instance is in other server. Also is it possible through SSMS Export-Import Wizard? – Shiva Mar 24 '14 at 10:05