If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Field Name with Special Characters
Hello,
I understand that special characters should not be used in table field names and I don't use them when creating tables in my databases. However, when I want to link to an Excel spreadsheet that another department is using to enter their data, sometimes they use a forward slash, ampersand, or other special character in the header name. Could this still cause a problem even though it is a linked Excel file? I have successfully tested quering a table, albeit a two-field table with three records, containing special characters in the field name. Any guidance is appreciated. Regards, Paul |
#2
|
|||
|
|||
Field Name with Special Characters
Try to link to the spreadsheet and see if ACCESS handles it ok.
When importing spreadsheets into tables, ACCESS often replaces "bad, special" characters with underscores, so if your linking doesn't work, you could try importing the data. -- Ken Snell MS ACCESS MVP http://www.accessmvp.com/KDSnell/ "Paul" wrote in message ... Hello, I understand that special characters should not be used in table field names and I don't use them when creating tables in my databases. However, when I want to link to an Excel spreadsheet that another department is using to enter their data, sometimes they use a forward slash, ampersand, or other special character in the header name. Could this still cause a problem even though it is a linked Excel file? I have successfully tested quering a table, albeit a two-field table with three records, containing special characters in the field name. Any guidance is appreciated. Regards, Paul |
Thread Tools | |
Display Modes | |
|
|