Using SQL to create an Excel Table

[PaulDON]

Im using an application Query Tool and i was looking to know does any one know the SQL commands to create a table in excel. Im using CREATE TABLE TEST ( MS INT ).

I get the error DeriveParameters: CommandText property has not been initialized

 

[SQLBill]

First, are you creating this table using an existing SQL Server database? Or is this strictly in Excel?

If this isn't using Microsoft SQL Server, then you need to post in an appropriate forum as this is specifically for SQL Server.

-SQLBill

Posting advice: FAQ481-4875