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 Expand view
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 Expand view
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