<div>
cheers for this <br />
<br />
have you used it?<br />
<br />
when i enter <br />
Data Source=C:\forecast.xlsx;Pr<wbr />ovider=Mic<wbr />rosoft.ACE<wbr />.OLEDB.12.<wbr />0;Extended<wbr /> Properties=”Excel 12.0;HDR=YES;”<br />
<br />
i keep getting an error stating &quot;&nbsp;Property value not Valid&quot; - hope i am not being dopy!<br />
<br />
mal
</div>


<div>
try this<br />
Data Source=C:\forecast.xlsx;Pr<wbr />ovider=Mic<wbr />rosoft.ACE<wbr />.OLEDB.12.<wbr />0;Extended<wbr /> Properties=”Excel 12.0&quot;;HDR=YES;
</div>


<div>
&quot;HDR=Yes;&quot; indicates that the first row contains columnnames, not data. &quot;HDR=No;&quot; indicates the opposite.<br />
<br />
refer<br />
<a href="http://www.connectionstrings.com/excel-2007" rel="ugc">http://www.connectionstrings.com/excel-2007</a>
</div>


<div>
ah yes - i was being a bit dopy :)<br />
<br />
cheers guys great help<br />
<br />
mal
</div>


<div>
<div class="content wysiwyg-content">
hi all<br />
<br />
just trying out integration services for the first time -(looks great), but can i read an excel 2007 file into sql rather than just 2003 and previous versions?<br />
<br />
our sql 2005 instance &nbsp;does not have sp2/3 installed<br />
<br />
cheers<br />
<br />
mal
</div>
</div>


hi all

just trying out integration services for the first time -(looks great), but can i read an excel 2007 file into sql rather than just 2003 and previous versions?

our sql 2005 instance  does not have sp2/3 installed

cheers

mal

cheers for this 

have you used it?

when i enter 
Data Source=C:\forecast.xlsx;Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties=”Excel 12.0;HDR=YES;”

i keep getting an error stating &quot; Property value not Valid&quot; - hope i am not being dopy!

mal

try this
Data Source=C:\forecast.xlsx;Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties=”Excel 12.0&quot;;HDR=YES;

&quot;HDR=Yes;&quot; indicates that the first row contains columnnames, not data. &quot;HDR=No;&quot; indicates the opposite.

refer
http://www.connectionstrings.com/excel-2007

ah yes - i was being a bit dopy :)

cheers guys great help

mal

SQL 2005 Integration services

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.