Unable To Access Linked Tables Via Microsoft Access

Benjamin O'Leary

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.

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

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