Let me be a bit more specific on the ETL case.

I use the IBM Data Manager ETL tool to create staging tables. Data Manager creates the new table automatically on...

Thanks for your replies. Here is an example.

Pull data from Excel table into a table that SQL Server 2012 creates.

SELECT * INTO TableName

FROM OPENROWSET('Microsoft.ACE.OLEDB.12.0',

'Excel 12.0 Xml;

...