You can create the Excel file using a SQL CREATE TABLE statement.
I am assuming when you say link you mean create some type of relation,
If so you can use the CDaoDatabase::CreateRelation() method.
You can modify the table using UPDATE, INSERT or DELETE SQL commands.
The Reamey Technology Group
:I'm trying to create new external files which can then be attached to
:my CDaoDatabase variable.
:create a new Excel file
:create a linked table in my mdb file
:modify the linked table.
:Does anybody know how I can do this?
:Thanks in advance.