G
Guest
I have a SQL database with only about 500 records. It originates from an
Excel file that I use to append the records. I created an append query in
Access to only appending one field (the KEY).
When I ran the query, (with 550 records - forty some new records) - it
didn't even run (I let it go over night). It runs in about 10 minutes on my
local SQL server. I went ahead and wrote a proceedure in Excel to download
the entire table and create a new file that contains only new records and one
field. I imported this table to an Access table (local) and ran the query
and it took an entire hour, just for forty some records.
Am I missing something or ??? I've already used Excel to identify which
records to append (which takes only a few seconds - including a SQL download
of the entire table) and just want to add the keys to this table - so it
could append blindly (without comparing) if this is an option.
I am using Access 2003 with a linked ODBC SQL tables and imported the Excel
file as a table in Access (with Access 2002-2003 file format)
Excel file that I use to append the records. I created an append query in
Access to only appending one field (the KEY).
When I ran the query, (with 550 records - forty some new records) - it
didn't even run (I let it go over night). It runs in about 10 minutes on my
local SQL server. I went ahead and wrote a proceedure in Excel to download
the entire table and create a new file that contains only new records and one
field. I imported this table to an Access table (local) and ran the query
and it took an entire hour, just for forty some records.
Am I missing something or ??? I've already used Excel to identify which
records to append (which takes only a few seconds - including a SQL download
of the entire table) and just want to add the keys to this table - so it
could append blindly (without comparing) if this is an option.
I am using Access 2003 with a linked ODBC SQL tables and imported the Excel
file as a table in Access (with Access 2002-2003 file format)