Hi,

Using Access, if we want to write to a table,
running cmd.commandText = " Create MyTable Field1 char(10), Field2 char(20)"
will make it

But in Excel, "Sheet1$",......"Sheet60$" are already there
I can not run that command as the Sheet already exist.

What can I do to add my data to a specified sheet with some specified columns?

Thanks for help