K
KennyF
I know there are many questions about duplicate data, but here is another
one. I have a linked SQL server table with over 500,000 records. The
records have many fields so the table is rather large. I only have rights to
read the SQL server table, so any manipulation of the data must be done on my
machine.
The SQL table has an ID field to make records unique, but there is another
field that I want to be the key that contains duplicates. I want to make a
local table with a query that eliminates the duplicate records. I can do
this by creating the table definition, creating a key on the field I want,
then append the records from the SQL table. Access will complain that there
are multiple key fields, but will let me run the query, deleting one of the
duplicates. How can I run that query using an VBA program? The execute
query line always returns an error. Any body have any suggestions?
Thanks for your help.
Ken
one. I have a linked SQL server table with over 500,000 records. The
records have many fields so the table is rather large. I only have rights to
read the SQL server table, so any manipulation of the data must be done on my
machine.
The SQL table has an ID field to make records unique, but there is another
field that I want to be the key that contains duplicates. I want to make a
local table with a query that eliminates the duplicate records. I can do
this by creating the table definition, creating a key on the field I want,
then append the records from the SQL table. Access will complain that there
are multiple key fields, but will let me run the query, deleting one of the
duplicates. How can I run that query using an VBA program? The execute
query line always returns an error. Any body have any suggestions?
Thanks for your help.
Ken