PatrickMcDonald/Excel From SQL Server.sql

Created February 26, 2015 16:30

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/PatrickMcDonald/a427d9f7290d01101a26.js"></script>
Save PatrickMcDonald/a427d9f7290d01101a26 to your computer and use it in GitHub Desktop.

Download ZIP

Import columns with mixed datatypes to SQL Server from Excel

Raw

Excel From SQL Server.sql

	SELECT *
	FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',
	'Excel 8.0;IMEX=1;Database=\\server\share\Spreadsheet.xlsx;', ['Sheet-Name$'])

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment