Problem joining two tables

  • Thread starter Michael Padvaganian
  • Start date

M

Michael Padvaganian

Hello I'm kinda new at Access and am having a problem. I
have a table that i load from a text file. The data
should have a unique field(s). The problem is that there
are some occurances of non unique data. I load the data
into a table and am able to query and locate the records
that dont belong in the data. The question is how do I
get these records out of my data. Can I join my table
with the query that locates the redundant data and
eliminate this data.

Thanks

Mike
 
Ad

Advertisements

H

Howard Brody

Import your text file into a temp table (a table you're
going to delete once you're done).
Run any scrubs on the data.
Run a query to select the unique records from the temp
table and append them into your main table.
Purge the temp table
Hope this helps!

Howard Brody
 

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

Join two tables with an expression? 1
how two join two tables on two fields 1
joining tables 1
joining tables 6
Joining two tables into one XML file 0
joining two queries 3
Join tables in Access 2
join 3 tables 0

Top