Dealing with Case sensitivity in MS Access
Posted on 2013-01-08
I have a series of table which I need to incorporate into a MS Access DB. The unique key in the source tables are from a DB structure where case is also considered so, where my source data defines 12345AB and 12345Ab as unique records, MS access states these are duplicates.
Any suggestions on how to tell MS Access that these are indeed to different records?