Importing Excel Files

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

Guest

Is there anyway when imoprting an Excel file to keep from putting duplicate
records in my database? Thanks for any help.
 
Tony,

In table design view, create an index on the field or combination of fields
that you wish to be unique (View, Indexes). Set the Unique property to Yes.
For a multiple-field index, leave the Name column blank except for the first
row.

Sprinks
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing .wab file from Outlook 2003 to 2007 8
Importing Excel Data and Comparing to Existing Data Records 4
Access Auto Matching Duplicates? 0
Recognizing data 1
date type format which is supported by excel 2003 2
Which is the best MBOX Converter Tool different formats conversion? 5
Writing SQL code to delete duplicate records 0
Can you down save a *.pst from office 2003 to use on office 2000? 1

Back
Top