How to use workbook is a database.
and each worksheet in the workbook is a data table in this manner.

So that i can use SQL statement to write.

Just setup a range name for each table, and then use ADO and SQL against the
workbook.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

<CH; "Leow" <CH, wrote in message
...
How to use workbook is a database.
and each worksheet in the workbook is a data table in this manner.

So that i can use SQL statement to write.

be mindful that there is an open MS bug on this one. The workaround is
that you issue your queries against a closed workbook . If you u do it
on an open workbook then excel wouldnt release the system resource
eventually resulting in a crash on repeated use.
learnt it the hard way .

Bob Phillips wrote:
Just setup a range name for each table, and then use ADO and SQL against the
workbook.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

<CH; "Leow" <CH, wrote in message
...
How to use workbook is a database.
and each worksheet in the workbook is a data table in this manner.

So that i can use SQL statement to write.