Kathy
August 18th, 1999, 02:14 PM
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
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