Unwanted Information

[mikeinohio]

I have an exsiting database with a table with approx. 1.3 million records in
it, i need to know how can i first create a table removing all but 3
columns, and delete any duplicate records?

 

[Smartin]

I have an exsiting database with a table with approx. 1.3 million records in
it, i need to know how can i first create a table removing all but 3
columns, and delete any duplicate records?

Hi mikeinohio

There are lots of posts on ways to remove duplicate records. Try google
groups on the topic and write back if you get stuck.

To create a new table use SELECT INTO, check F1 for help on "make table"
queries for more on this. You can of course write only three fields to
the new table if desired.

Hoping this helps,

 

['69 Camaro]

Hi, Mike.

I have an exsiting database with a table with approx. 1.3 million records
in
it, i need to know how can i first create a table removing all but 3
columns, and delete any duplicate records?

Create a make-table query, but use the DISTINCT keyword to select only the
unique records from the data source. In the following example, FName,
LName, and DOB are the three selected columns that will be copied into the
new table, tblNoDuplicates is the new table, and tblBigTable is the original
table.

SELECT DISTINCT FName, LName, DOB
INTO tblNoDuplicates
FROM tblBigTable;

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[mikeinohio]

sweet it worked thanks alot!

Hi mikeinohio

There are lots of posts on ways to remove duplicate records. Try google
groups on the topic and write back if you get stuck.

To create a new table use SELECT INTO, check F1 for help on "make table"
queries for more on this. You can of course write only three fields to
the new table if desired.

Hoping this helps,