Review the names of your tables and columns. Objects in Microsoft® Access can contain spaces, for example, January Orders. Objects in Microsoft SQL Server™ cannot contain spaces unless it is a delimited identifier. You may want to replace the space with an underscore character or use capitalization to separate the portions of the names, for example, JanuaryOrders.
| Access | SQL Server |
|---|---|
| Identifier names can include any combination of letters, numbers, and special characters except: a period (.), an exclamation point (!), an accent grave (`), and brackets ([ ]). | Identifier names must begin with a letter as defined by the Unicode standard or a character _ (underscore), @ (at sign), or # (number sign), and contain letters as defined by the Unicode standard, decimal numbers from either Basic Latin or other national scripts, or the characters _, @, $ (dollar sign), and #. |
| Identifier names can be from 1 through 64 characters in length. | Identifier names can be from 1 through 128 characters in length. |
In Access, object names are case-sensitive. In SQL Server, object names can be case-sensitive, depending on the character sort order that is installed. The sort order is chosen in SQL Server Setup during installation. The default sort order in SQL Server is dictionary order, case-insensitive.