Have put together various query templates for appending data that is imported. User now is requesting to have the query prepopulated with all the fields from the import table, rather than have to predefine or drag them onto the grid. I can through vba create a select statement that lists all the fields, but haven't figured out the equivalent of clicking on the (green +) Append Query button in design view which automatically attempts to map the fields to the destination table. Short of building the query as a select query, opening in design view and telling the user to click the Append query button, can this be done or do I need to know all the fields ahead of time in order to do this as there won't be a 1 to 1 match, meaning that not all fields in the source table are in the destination table as well as the fact that the field names may differ.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.