Import and Intergrate New data into Existing DB in MS Access
$100-500 USD
Terminado
Publicado hace alrededor de 15 años
$100-500 USD
Pagado a la entrega
1. The objective of the project is fairly simple. The objective is to import new data from about 110 excel files into the existing data base in MS Access.
2. By matching both fields Contact and Company, import new data for the available fields
3. When you match both company name and full name, if there is existing record in the master DB, import the available data from the new file into the matching fields in the existing record.
If the value of the imported field is blank or Null in the new file, do not overwrite the contents of the existing data in that field.
The ACCOUNTNO field is a protected field. Do not modify or overwrite contents of this field.
4. When you match company name and full name, if there is no existing record, import as new record with all the available fields.
5. After importing of the data from the new file into the existing DB, sort the master DB by Company and Contact fields.
## Deliverables
**Specifications for the Project**
1. The objective of the project is fairly simple. The objective is to import new data from about 110 excel files into the existing data base in MS Access.
**2. By matching both fields Contact and Company, import new data for the available fields**
**3. When you match both company name and full name, if there is existing record in the master DB, import the available data from the new file into the matching fields in the existing record.**
**If the value of the imported field is blank or Null in the new file, do not overwrite the contents of the existing data in that field.
The ACCOUNTNO field is a protected field. Do not modify or overwrite contents of this field.**
**4. When you match company name and full name, if there is no existing record, import as new record with all the available fields.
5. After importing of the data from the new file into the existing DB, sort the master DB by Company and Contact fields.**
6. I have attached Old Master DB in MS Access and 2 sample excel files, New Data 1 and New Data 2. Import the data from the 2 sample excel files into the Master DB. Please email the Integrated Master DB in Access format to me.
7. If I am satisfied with the results and pricing for the project, I will send the entire master DB in MS Access and new data in 110 excel files. The data from the 110 excel files need to imported and integrated into master DB as explained above. I need the project to be completed in 1 or 2 days.