You can also execute the query against the source in a passthrough manner by using OPENQUERY as follows: SELECT * INTO XLImport2 FROM OPENQUERY(EXCELLINK, 'SELECT * FROM [Customers$]')
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)