Steps to update Table from Excel Doc.

[browniefdb]

I've recenlty been tasked with updating a field in a table, Class Code,from an excel spread sheet. The Source is an Excel doc which has a duplicate column that holds the updated information. This Column needs to be merged with the field in the Class Code Tbl. There are blanks in Class Code Tbl. that need udating.

In my first attempt i imported the excel doc. into access. i then created query bringing in both tables and linking the two common columns. In an attempt to run it i received an error "Type mismatch in expression" I'm just learning alot so i may not be going about the process correctly. Pls. advise. Under deadlines and a learning curve.

[ADezii]

I've recenlty been tasked with updating a field in a table, Class Code,from an excel spread sheet. The Source is an Excel doc which has a duplicate column that holds the updated information. This Column needs to be merged with the field in the Class Code Tbl. There are blanks in Class Code Tbl. that need udating.

In my first attempt i imported the excel doc. into access. i then created query bringing in both tables and linking the two common columns. In an attempt to run it i received an error "Type mismatch in expression" I'm just learning alot so i may not be going about the process correctly. Pls. advise. Under deadlines and a learning curve.

You may have Linked the 2 common Columns but they are not the same Data Type. e.g. You cannot Link an [ID]{Text} Column to an [ID]{Long Integer} Column. The Linked Fields must be of the same Data Type with the exception that an AutoNumber Field, which in reality is a Long Integer, can be linked to a Long Integer Field. Hope this solves your problem

[NeoPa]

Can you post some example data.
Sometimes Excel can work in a 'Big Brotherish' way and make decisions on your behalf. ADezii's post should help you resolve the issue, but if you come across an example of Excel treating data in a way that's different from how you want it to then we may need to dig a little deeper.
Obviously, only post the data if you feel a need and you haven't been able to resolve the issue already.