Try this example using the pubs database

insert into

OpenDataSource( 'Microsoft.Jet.OLEDB.4.0',

'Data Source="c:\temp\wow.xls";User ID=Admin;Password=;Extended properties=Excel 5.0')...[Sheet1$]

select * from authors

Note: The spreadsheet must exist, and must have the same number of...