Add Table Name as Field in an Append Query



Is there a way to include a table name in a query?
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?

Jeff Boyce

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

More info, please...


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