Unable To Access Linked Tables Via Microsoft Access
Hello,
I have recently connected my Smartsheet tables to Microsoft Access 2016 via Smartsheet Live Connector. However, when I try to import/link these Smartsheet tables to Access, I am getting an error stating that my Smartsheet tables are too long and therefore can't be imported/linked. It seems that the Live Connector has added a bunch of characters to my tables, and I don't know how to fix it.
I have attached some screenshots to better help explain what I'm seeing. Any help would be greatly appreciated.
Benjamin O.
Best Answer
-
Do you have to use the long name from the ODBC Source when linking? It's been a long time since I used Access.
Maybe try re-naming the sheet all together. There could inadvertently be a un-obvious special character in the name. I've seen that happen when something was copy and pasted, an indistinguishable non-ASCII character caused me a lot of trouble.
Check out the options you have in the ODBC connection Manager. ctrl+S "ODCB"
I would check, but not on a Windows machine right now.
It looks like the Sheet ID & Workspace name are getting appended to the sheet name.
Here's the Access Specs
Answers
-
Do you have to use the long name from the ODBC Source when linking? It's been a long time since I used Access.
Maybe try re-naming the sheet all together. There could inadvertently be a un-obvious special character in the name. I've seen that happen when something was copy and pasted, an indistinguishable non-ASCII character caused me a lot of trouble.
Check out the options you have in the ODBC connection Manager. ctrl+S "ODCB"
I would check, but not on a Windows machine right now.
It looks like the Sheet ID & Workspace name are getting appended to the sheet name.
Here's the Access Specs
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives