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
 

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 Issue 0
Append to two different tables 23
Append query - Append to table with Autonumber field 2
Append Query To Table 3
Invalid Argument - Append Query 1
AutoNumber Field Not Populating with Append Query 2
Criteria in append querie 3
Data changes in append query 1

Back
Top