soberealtor
Junior Member
- Jun 8, 2009
- 134
- 35
Cannot find this. Tried ablebits for excel free trial...is there any other program?
Need to remove duplicates from excel or txt file...what software to use?
- Thread starter soberealtor
- Start date
popcrdom29
Senior Member
- May 20, 2008
- 850
- 549
Excel 2007 or 2010 is much easier to use. If you don't have it you can download it from some file sharing sites.
soberealtor
Junior Member
- Jun 8, 2009
- 134
- 35
iam assuming it had a duplicate removal stock now...might as well upgrade now...thanks
darkmobius
Regular Member
- Jul 16, 2008
- 238
- 228
textpad can sort and remove dups for you and its free
- Sep 1, 2009
- 1,210
- 296
I'm assuming that since you have Microsoft Excel, you have (or can get) Microsoft Access.
Import the files into an Access MDB.
Create a new query, and go to the SQL view...
SELECT DISTINCT
FIELD1
,FIELD2
,FIELD3
,.and so on
FROM yourtablename
The result will be a de-duplicated version of the original table. "SELECT DISTINCT" is ANSI SQL, so it will also work in MySQL, SQL Server Express, or any other flavor of SQL you might have or any product that has a SQL interpreter (FoxPro, etc.).
Feel free to PM me if you need some more help.
-SDT
Import the files into an Access MDB.
Create a new query, and go to the SQL view...
SELECT DISTINCT
FIELD1
,FIELD2
,FIELD3
,.and so on
FROM yourtablename
The result will be a de-duplicated version of the original table. "SELECT DISTINCT" is ANSI SQL, so it will also work in MySQL, SQL Server Express, or any other flavor of SQL you might have or any product that has a SQL interpreter (FoxPro, etc.).
Feel free to PM me if you need some more help.
-SDT
darkmobius
Regular Member
- Jul 16, 2008
- 238
- 228
This came in handy, thanks! Need to remove duplicates asap to start posting.
I'm glad it's handy to you, I use this both at work and at home.