Dynamically adding fields from temp table to perm table if dont exist

[RCBricker]

I have a table that I created with the first import of a report from my client. The issue is that the # of fields change every month (growing and shrinking ::SMH) as well as new field names appearing at random months and old ones coming and going. Unfortunately, the client knows and is not doing anything to standardize the uploads.

My question is:

Is there a way to upload the file to a temp table and then have vba match fields with the same name, and ADD fields that do not exist?

 

[xenou]

This page helps with vba for changing table structure with code:
Microsoft Access tips: DAO Programming Code Examples

As far as loading to a temp table you can just pull the data into a new table and it gets the field names as they are in the "file" (excel?). Be careful that the data import is clean - blanks, mixed data types, alphanumerics can all be trouble.

 

[RCBricker]

This page helps with vba for changing table structure with code:
Microsoft Access tips: DAO Programming Code Examples

As far as loading to a temp table you can just pull the data into a new table and it gets the field names as they are in the "file" (excel?). Be careful that the data import is clean - blanks, mixed data types, alphanumerics can all be trouble.

The temp table is used to update existing table. The only time new tables are created is when a new data source is added.

Thanks for the link.