Forum Discussion

Simon Pearce's avatar
Simon Pearce
Copper Contributor
May 02, 2018
Solved

Excel web query DataFormat.Error "not a valid path"

Hi,    I have a workbook that grabs data from a few online Excel workbooks. This was working fine from when I set it up about six months ago until recently, when it started producing a DataFormat.E...
Excel 2016
Query
  • SergeiBaklan's avatar
    SergeiBaklan
    May 02, 2018

    It looks like XML schema for your Excel is customized, perhaps that's the reason.

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
May 02, 2018

Hi Simon,

 

Could you please attach sample workbook with this error? I queried URL with Get & Transform and see no issues - attached.

mdalifmondol's avatar
mdalifmondol
Copper Contributor
Apr 16, 2021

SergeiBaklan 

Dear sir i need your help 

i am used nice label software .excel file or database file not conation.

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Apr 16, 2021

    mdalifmondol 

    I'm not sure how may I help, MS Access can't find the file in your Desktop folder. If check by File Explorer are you sure the file is still at this folder?

    • mdalifmondol's avatar
      mdalifmondol
      Copper Contributor
      Apr 27, 2021
      My Skype name mdalifmondol
      I many many try this problem face
      but this problem are not solve
      can you help me I need a software to this problem solve

Resources