Skip to content

Instantly share code, notes, and snippets.

@keithbloom

keithbloom/example1.sql

Created October 27, 2011 07:36
Show Gist options
  • Save keithbloom/1318983 to your computer and use it in GitHub Desktop.
Save keithbloom/1318983 to your computer and use it in GitHub Desktop.
Download ZIP
ExcelInSql
Raw
example1.sql
SELECT u.[region 1], s.full_name AS RegionalManager
FROM OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', 'Data Source=c:\managers.xls;Extended Properties=Excel 8.0')...Updates$
JOIN staff s
on s.id = u.staff_id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment