B
BRN
Hi, I'm a new user and I'm trying to run a query from some linked tables,
however I am getting a message saying type mismatch. I understand that fields
which 'match' (those which I've created a relationship between) in each table
must be the sametype, however I cannot change the type in design view as it
says 'MS Access can't save property changes for linked tables'. So, I tried
to change the format of cells (all to text) directly in the excel file and
linked the table again, but this did not work. Some fields are text and some
are numbers in the Access table. Does anyone have a solution to this problem?
Any help would be greatly appreciated! (I'm using MS Access 2000). Thanks!
however I am getting a message saying type mismatch. I understand that fields
which 'match' (those which I've created a relationship between) in each table
must be the sametype, however I cannot change the type in design view as it
says 'MS Access can't save property changes for linked tables'. So, I tried
to change the format of cells (all to text) directly in the excel file and
linked the table again, but this did not work. Some fields are text and some
are numbers in the Access table. Does anyone have a solution to this problem?
Any help would be greatly appreciated! (I'm using MS Access 2000). Thanks!