Handy SQL Script

Today, I used the following SQL Script to import data from an Excel file into a database table.

INSERT INTO
    Users (FirstName, LastName)
SELECT
    *
FROM
    OPENROWSET( 'Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=C:\Users.xls', 'SELECT * FROM [Sheet1$]')