Import CSV Data into Multiple Existing Tables in Access and Check for duplicates

  • Posted:
  • Proposals: 7
  • Remote
  • #105681
  • Archived
David S.Carl W.Mike B.Steve W.Art W. + 2 others have already sent a proposal.
  • 1

Description

Experience Level: Expert
We are looking to import our internet orders as a csv file into our order process database (Access 2010 with a split back/front end). Each order need to update 5 tables and create the correct links between them. The tables are Customers, Orders, Jobs, Addresses and telephone numbers. We also want to ensure that as the records are brought in they aren't duplicating any info (e.g. re entering an existing customer).

New Proposal

Create an account now and send a proposal now to get this project.

Sign up

Clarification Board Ask a Question

    There are no clarification messages.