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.

Find more posts tagged with

Accepted answers

JeremiahHorstick

@Benjamin O'Leary

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

All comments

JeremiahHorstick

@Benjamin O'Leary

Do you have to use the long name from the ODBC Source when linking? It's been a long time since I used Access.

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

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.