Hi,

It should be working:

SELECT *

INTO test_import

FROM OpenDataSource

('Microsoft.Jet.OLEDB.4.0','Data Source="c:\xyz.xls";User ID=;Password=;Extended properties=Excel 5.0')...['adCOI_TA-DAL328416$']

Regards,

Attila Meglécz