Creation of MDB, add tables & append DBF data with ADORD

[RAMESHBABU]

Hi

Can anybody guide me with a working sample to create a Database
with two tables and after creation, I need to populate the tables from
two individual .DBF files using APPEND FROM ... command using ADORDD.

I found a sample "ACCESS1.PRG" which is creating the databse with a
table. I need to create the databse alongwith two tables. I don't know
how to accomplish it.

Code: Select all

DbCreate( "test2.mdb;table1", { { "FIRST",  "C", 10, 0 },;
                                               { "LAST",    "C", 10, 0 },;
                                               { "AGE",     "N",   8, 0 } },;
                                               "ADORDD" )

How to add another table to test2.mdb ?

Code: Select all

USE test2.mdb VIA "ADORDD" TABLE "table1"

How to append data from a .DBF file to table1 ?

Any working sample please

Thanks

- Ramesh Babu P