importing and updating records

i've imported records into an access database, but found
another folder containing the same records with new
information and new additional records. How can i
successfully import this info into access with erasing
the old record information

There are a couple of ways you can accomplish this. In a one time import, you can bring the new spreadsheet into a table in Access and if the fields are not exactly the same as the original table, you can make an Append Query where you can assign the new fields to the existing table. If the fields are the same, you can copy from the new table and Paste/Append into the old one. Do you have key fields that may cause a problem? If you have established key fields, you may loose records on the append. It all depends on your data.


----- lisa wrote: -----

i've imported records into an access database, but found
another folder containing the same records with new
information and new additional records. How can i
successfully import this info into access with erasing
the old record information

The import fields are exactly the same. By importing the
speadsheet file, the data will be either new records or
new information for existing records (like new address,
telephone, etc). Will Access create a new record for the
existing records and cause me to run a query to append
the record to keep the database clean from dupes? The key
is the same in both files.

-----Original Message-----
There are a couple of ways you can accomplish this. In
a one time import, you can bring the new spreadsheet into
a table in Access and if the fields are not exactly the
same as the original table, you can make an Append Query
where you can assign the new fields to the existing
table. If the fields are the same, you can copy from the
new table and Paste/Append into the old one. Do you
have key fields that may cause a problem? If you have
established key fields, you may loose records on the
append. It all depends on your data.


----- lisa wrote: -----

i've imported records into an access database, but
found
another folder containing the same records with new
information and new additional records. How can i
successfully import this info into access with
erasing
the old record information

.

What I would do in this case is run a couple of queries. First I would create a delete query where the key field in the original table are the same as the new table (equals join). Otherwise, it will not append the new information for those records. Then, I would run the append query to get all new (and updated) records.
You would need to be cautious however, if you have referential integrity set up with the original table. You do not want to delete those records if it will cause a record to be deleted in a linked table.

Hope this helps.



----- lisa wrote: -----

The import fields are exactly the same. By importing the
speadsheet file, the data will be either new records or
new information for existing records (like new address,
telephone, etc). Will Access create a new record for the
existing records and cause me to run a query to append
the record to keep the database clean from dupes? The key
is the same in both files.

-----Original Message-----
There are a couple of ways you can accomplish this. In
a one time import, you can bring the new spreadsheet into
a table in Access and if the fields are not exactly the
same as the original table, you can make an Append Query
where you can assign the new fields to the existing
table. If the fields are the same, you can copy from the
new table and Paste/Append into the old one. Do you
have key fields that may cause a problem? If you have
established key fields, you may loose records on the
append. It all depends on your data.
----- lisa wrote: -----
i've imported records into an access database, but
found
another folder containing the same records with new
information and new additional records. How can i
successfully import this info into access with
erasing
the old record information
.