Finding matching fields (columns) between two tbls to add only the required columns to tbl1

[Datamulcher]

Hey brilliant folks!

My problem is:

I have 2 tables. One is in use in the database already and its purpose is to supply company information when a Coder clicks an "Expand for company information" field in a datasheet form. This table is not complete as information was supplied to us after data entry by companies providing excel sheets with the company information.
The excel sheets do not match the CompanyInfo table layout and field order. They also have a different selection of fields.
So they cannot be directly imported & then appended to the CompanyInfo table.

I need a query to identify the fields which do match. From there then a query append only those fields only to the CompanyInfo table- in the right order.

Fields in the Excel Sheets:

I have spent too much time trying to figure this out already while I have 80+ workitems to complete today. I gave it half an hour, asked a colleague - no luck.

An Excel file is attached with the fields laid out. (No macros, nothing devious)


Help......zip

I wish to create an update query to update all the fields in the tblComanyInfo with the corresponding fields from the excel.
I'm pretty sure you guys (and gals) will know exactly what to do! So there's the problem and thanks in advance for the help I know you always provide!

[jwhite]

Data conversions aren't usually requested of volunteers on forums to do for posters, although someone with a lot of free time might. I wouldn't. This is a for-hire situation.

[Datamulcher]

Really? 0_o
I have received assistance for muuuuuuuuuuuuuuuuuch more difficult circumstances than "find matching fields".
This would take a coworker 1 minute to do, but I don't want to bother the research data analyst for something trivial like this and instead thought I would take the opportunity to learn a tidbit from the helpful folks here.

I'm not requesting that anyone perform the "data conversion" just a reply like "use an update query with the criteria 'is not null' on all fields".
Also, not sure this would fall under data conversion. This could be done within excel. Or after importing the table to access.
Its not about different formats, its just how to update fields which do exist within a table while ignoring those that do not.