Add Table Name as Field in an Append Query

R

Ripper

Is there a way to include a table name in a query?
Scenario:
Outlook Calendar exported to Excel
Database contains 16 linked tables that are named for each person's
calendar export
Append Queries compile each linked table into one large table
Need a field in the compiled table that identifies the individual associated
with each record
Would like to include a field in the Append query which is equivalent to the
linked table name so that it appends into the large compiled table.
Any ideas?
 
J

Jeff Boyce

I'm having difficulty visualizing your data structure. For example, why
would one person have "16 linked tables"?

More info, please...

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append query - Append to table with Autonumber field 2
Create field from append query based on linked table name 1
Invalid Argument - Append Query 1
Append to two different tables 23
Linked Tables Append Query(ies) 4
Only first few records visible in table after running append query 1
Append query 1
Linked value in append query gives symbol value 2

Top