Add Table Name as Field in an Append Query

  • Thread starter Thread starter Ripper
  • Start date Start date
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?
 
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
 
Back
Top