The ADO command object is good for running stored procedures or using parameterized selects and inserts like in the example.

If you want want to build a table, there are several methods. Using CREATE TABLE with the execute method of the connection object and ADOX come to mind.

-Dave



>Just wonder who has done anything with the Command object with ADO 2.7 on the VFO7 OLEDB driver. I was checking out
>
>http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdconcommandparams.asp
>
>And thought I could use it to build a table quickly and it's not working. I am coding this from VBScript 5.6 (Windows Script Host on Win2K).
>
>Thanks.