Import data from dbaseIII and want to update an existing table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello
I want to import data from dbase3 to a spedcified table in Access. Every time I try to import the data, Access creates a new table. But I need the data to update an existing table. Are there any suggestion that would help
Thanks
Le Tran
 
You can link to the dBase III table and then write an Append Query which
specifies which of the dBase III records will be appended into your Access
table.

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX


Le Tran said:
Hello,
I want to import data from dbase3 to a spedcified table in Access. Every
Click to expand...
time I try to import the data, Access creates a new table. But I need the
data to update an existing table. Are there any suggestion that would help.
 
From Access Help -

1. Create a query that contains the linked dBase III table whose records
you want to append to another table.
a. In the Database window, click Queries under Objects, and then
click New on the Database window toolbar.
b. In the New Query dialog box, click Design View, and then click OK.
c. In the Show Table dialog box, click the tab that lists the tables
or queries whose data you want to work with.

2. In query Design view, select Query from the Menu, and then click Append.
The Append dialog box appears.

3. In the Table Name box, select the name of the table you want to append
records to. Click OK.

4. Drag from the field list to the query design grid the fields you want to
append and any fields you want to use for setting criteria.

5. If the fields you've selected have the same name in both tables,
Microsoft Access automatically fills the matching name in the Append To row.
If the fields in the two tables don't have the same name, in the Append To
row, enter the names of the fields in the table you're appending to.

6. In the Criteria cell for the fields that you have dragged to the grid,
type the criteria on which additions will be made.

7. To preview the records that the query will append, click View on the
toolbar. To return to query Design view, click View on the toolbar again.
Make any changes you want in Design view.

8. Click Run on the toolbar to add the records.
 
Back
Top