single &double quotes in identifiers (table & field names)
Posted: Sun Feb 26, 2017 10:02 pm
Access does allow table names and field names to have single and double quotes in them. But they don't work very well in SQL.
I suggest having an option to filter them out, or at a minimum flagging them before the conversion process starts so that the user can remove them in Access before proceeding.
In the past I had Access table names like this:
Sharon's costs
And Access field names like this:
len' -for length in feet
len" - for length in inches
(This was nice because it kept field names short. Much better than len-inches or len-in or len(i) or iLen.)
I suggest having an option to filter them out, or at a minimum flagging them before the conversion process starts so that the user can remove them in Access before proceeding.
In the past I had Access table names like this:
Sharon's costs
And Access field names like this:
len' -for length in feet
len" - for length in inches
(This was nice because it kept field names short. Much better than len-inches or len-in or len(i) or iLen.)