Link to home
Avatar of 9XqUwH3S
9XqUwH3SFlag for United States of America

asked on

Linking Tables: Error ('Type Mismatch in Expression')

I'm trying to figure out what I need to do to make my new linked table work in place of my old table (by the same name). I removed the old table by the same name and I made sure that the data types in the Excel spreadsheet match the data types in the old Access table.

I'm wondering if the source of the 'mismatch' has anything to do with the autonumber datatype that is not in Excel.

This is the only obsticle that I can see that is stoping me from making my new database operational with my old tables.
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Well we're all blessed with ESP in the forum so we know exactly what you are talking about.
Avatar of 9XqUwH3S

ASKER

Simply telling me which kind (s) of information needed to understand the question will help me to give exactly what will state the problem best.
ASKER CERTIFIED SOLUTION
Avatar of peter57r
peter57r
Flag of United Kingdom of Great Britain and Northern Ireland image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial