Solved

Cannot update Azure Table with Excel Add-In (trial version)

  • 16 November 2023
  • 2 replies
  • 24 views
V
Badge

Hi, 

I’m trying to update records in an Azure Table with the trial version of the CData Excel Add-In for Azure Table Storage (v23.0.8716). I’ve tried using both an Access Key and a Shared Access Token.

I can load the data in Excel without issue but cannot update. I keep getting the following error message:
“The url must be a valid http or https url”

Has anyone else seen this? Is this a limitation of the trial version?

Thanks
 

icon

Best answer by Ankit Singh 16 November 2023, 15:48

View original

2 replies

Ankit Singh
Userlevel 5
Badge +1

@vburd There are no limitations with the trial version of the products. This specific issue requires a bit of investigation. I’d encourage you to open a Support ticket with CData Support here: https://www.cdata.com/support/submit.aspx.

That Solutions Guy
V
Badge

To close this off, there was a bug when specifying the tables property in the connection string. Once I removed that, the update worked. CDATA provided me with an updated version which solves the issue.

Reply


Virtual Event: Data Virtualization, Reimagined Ma”arch 14, 2024 style=
Terms and ConditionsCookie settings