Linking table. Message error "... not a valid name. Make sure that it doesn't include invalid characters or punctuation and that it is not too long"

[albertan]

I'm trying to link to SAP Hana tables and view those in Access. However I'm getting an error like above. I suspect that table name is too long. But it is in source. Is there any way for me to fix this and avoid this error?

 

[jackd]

I found this video, but I don't use SAP and have not tested any of the things in the video.
Good luck.

 

[albertan]

Thank you for this, however this video shows how to connect to SAP Hana, which is not a problem I'm having. I could connect to most tables but only the ones with long names I could not connect. I believe it is a problem #3 as in this document Errors using special characters in Access databases - Office
But I don't know how I can avoid it because I cannot change the table names in SAP Hana source.

 

[albertan]

I found another source information. Linking Microsoft Access 2010 Tables to a SQL Azure Database
However, I cannot perform step 12 because I don't have access from SQL Management Studio to SAP Hana and I cannot rename tables in SAP Hana source. Not sure what could be alternative. I can probably link tables I can link and deal with the other tables manually or link them through Excel...

 

[albertan]

I posted this question in Stack Overflow to see if I can get some follow up answer

Error linking MS Access to SAP Hana database

I am trying to link an Access 2016 DB to tables in a SAP Hana database using ODBC. When I try to link to tables " '_SYS_BIC_XYZ_PUBLISHED_Customer_Service_Tran/CVC_SERVICE_ORDER_ACTUAL_COST_RE...

stackoverflow.com