IMPORT DBASE3 TO ACCESS DB

[zebra]

I am using the ledger wizard and have the table set up - but I want to
import the data from my dbase3 into the access db. How can I do that please.
If I export the dbase3 to CSV, can I somehow import it the access table.
See if I just import the dbase3 the field names are all wrong. Thanks a lot
anybody

 

[Damien McBain]

I am using the ledger wizard and have the table set up - but I want to
import the data from my dbase3 into the access db. How can I do that
please. If I export the dbase3 to CSV, can I somehow import it the
access table. See if I just import the dbase3 the field names are all
wrong. Thanks a lot anybody

New table - import table - find the csv file then follow the wizard. The
text file import wizard gives you the option of naming or re-naming the
fields and specifying the daya type. You can then append the data to the
existing table with an allend or update query.

Or you can create a link table linked to the dbase3 table and use the append
or update query in the same fashion (the field names don't have to be the
same).

If there aren't more than about 60000 records you can just copy then paste
append provided the layout and data types are the same.

Damo