Table extract question

[Dennis]

I need to be able to extract data from multiple tables
(and fill other multiple tables) based upon:

- A key value entered in a form

- A flat-file with the desired keys in it

Please, can someone tell me how to accomplish this?

Any insight or assistance would be greatly appreciated.
(Access 2002 on Win2K)

Thanks!

 

[John Vinson]

I need to be able to extract data from multiple tables
(and fill other multiple tables) based upon:

- A key value entered in a form

- A flat-file with the desired keys in it

Please, can someone tell me how to accomplish this?

Not without some more information. A Query would clearly be indicated,
but how you would construct this query is anyone's guess with the
information you've posted.

One concern: if you're "extract[ing] data from multiple tables [to]
fill other multiple tables" your table structure may need examination.
Storing the same data in two different tables is almost never a good
idea; redundancy is exactly what relational databases are designed to
prevent!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps

 

[Guest]

The source tables are read-only SQL tables. The data
extract would be willing R/W tables created in Access,
which would include only selected columns from each source
table. These tables would then be used to created "in-
work" tasks which would be updateable by several different
people. Once the work was complete, the affected items
would be flagged as "closed/complete".

Does that help?

Dennis

-----Original Message-----

I need to be able to extract data from multiple tables
(and fill other multiple tables) based upon:

- A key value entered in a form

- A flat-file with the desired keys in it

Please, can someone tell me how to accomplish this?

Not without some more information. A Query would clearly be indicated,
but how you would construct this query is anyone's guess with the
information you've posted.

One concern: if you're "extract[ing] data from multiple tables [to]
fill other multiple tables" your table structure may need examination.
Storing the same data in two different tables is almost never a good
idea; redundancy is exactly what relational databases are designed to
prevent!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
.

 

[John Vinson]

The source tables are read-only SQL tables. The data
extract would be willing R/W tables created in Access,
which would include only selected columns from each source
table. These tables would then be used to created "in-
work" tasks which would be updateable by several different
people. Once the work was complete, the affected items
would be flagged as "closed/complete".

Does that help?

Yes, thank you!

I would suggest that you create the local Access "target" tables with
your preferred datatypes and field sizes. You could include a Yes/No
field [Complete] for later use. You could then create Append queries
based on the linked SQL tables, appending the desired fields and
records to the empty local tables. Running these queries would bring
the data over from SQL into the local tables.

See the online help for Append; or use SQL -

INSERT INTO localtable (field1, field2, field3)
SELECT FieldA, FieldB, FieldC
FROM <SQL table or view name>
WHERE <conditions>

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps