Re: Bulk Update To Db Tables

There is still not enough information to provide specifics, Hoop, but it
probably will involve a query per table.
As to whether to use append or update queries, it depends on whether you are
adding new rows or making changesto existing rows in your tables. Append
queries add new rows and update queries modify existing data.

My personal practice is to clear the data in the import table before in
import into it just in case there was an error in the previous load and left
old data in the import table.

Then I execute the append queries and if there are any update queries to
reform the data I run those.

I don't clear the import table at this time so if I need to back out the
mods and start over, I don't have to do the import again if it is not
necessary.


As to the order, you need to follow the realtion path. Start with the
highest level parent table, then go to the next level, and if there are more
levels, continue in that order.
"Hoop" <Hoop@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F7AFBBAD-4523-47CC-BF91-B395A09E400B@xxxxxxxxxxxxxxxx
Hi Klatuu, thank you for the response. Could you give me a little more
information? Which query would I use, append or update or does it matter.
Do I simply create a query for each table? So if my db split into 8
separate
tables, I create a query for each of the 8 tables, pulling data from the
import table? (which would have ALL of the data in it? And then run each
of
the 8 queries one at a time? And then delete the data in the import
table?
Would it matter which order I run the queries in? When I import into my
master table now, I have the primary key set to "indexed, no duplicates",
and
the query I'm using now simply refuses to import duplicates based on the
primary key. Would I set the primary for each of the 8 tables the same
way
and the 8 queries would do the same thing? I know this is lengthy, but I
appreciate all the help. Thanks, Hoop

"Klatuu" wrote:

Use append and/or update queries.

"Hoop" <Hoop@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:ADA4C9E3-DB7D-409E-A972-6075424287D0@xxxxxxxxxxxxxxxx
Hi, up to now I have been using a single master table for my inventory,
with
all of the duplicate date. I have figured out how to split the table
so
that
it works quite well, eliminating the duplicate data. But I can't
figure
out
how to add to the tables without doing it one at a time through a form.
I
need to be able to update the tables with thousands of records at a
time.
How do I do this? Thank you, Hoop





.

Relevant Pages

  • Re: Bulk Update To Db Tables
    ... above that have lots of duplicate entries. ... I guess the Update Query would do the trick? ... As to whether to use append or update queries, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Bulk Update To Db Tables
    ... above that have lots of duplicate entries. ... I guess the Update Query would do the trick? ... As to whether to use append or update queries, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Membership database updates
    ... When you open any Query in Design View, click on the toolbar just next to ... black down-arrow where you can change your query to an Append or Update ... If you have any current members in your Import list, ... You mention Update Queries and Append Queries but I can't find how to ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Bulk Update To Db Tables
    ... above that have lots of duplicate entries. ... I guess the Update Query would do the trick? ... As to whether to use append or update queries, it depends on whether you are ...
    (microsoft.public.access.tablesdbdesign)
  • RE: Dynamically referencing a recordset?
    ... through that recordset to set the query parameters in VBA. ... to be the one who had to modify 1440 queries if there is a change in the ... different table schema, then you need 3, one for each record type. ... This is a database that tracks the production on records in another ...
    (microsoft.public.access.modulesdaovba)
Loading