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

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

Postby RAMESHBABU » Tue Dec 18, 2007 9:41 am

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  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
User avatar
RAMESHBABU
 
Posts: 624
Joined: Fri Oct 21, 2005 5:54 am
Location: Secunderabad (T.S), India

Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: nageswaragunupudi, Willi Quintana and 102 guests