Unable To Access Linked Tables Via Microsoft Access

Options

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

  • JeremiahHorstick
    JeremiahHorstick ✭✭✭✭✭✭
    edited 01/21/21 Answer ✓
    Options

    @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

Answers

  • JeremiahHorstick
    JeremiahHorstick ✭✭✭✭✭✭
    edited 01/21/21 Answer ✓
    Options

    @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