Error returned: 'OLE DB or ODBC error: [Expression Error] The column 'X' of the table not found...'

[See_Mun]

Hi there,

Keep getting the same error messages:

Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [Expression.Error] The column 'X' of the table wasn't found.. '.

Query parameters Parameter4 Failed to save modifications to the server. Error returned: 'OLE DB or ODBC error: [Expression.Error] The column 'X' of the table wasn't found.. '.

I've been struggling with this error for the whole day! Look through all the files in the folder, all column names (header) match in all of them. Tab names are all the same. Cleared cache etc, but still can't fix the problem.

I'd be grateful if you can shed any light on this. Thank you.

best wishes,

See Mun

[SarahC97]

I requested for an item to be added to one of the excel files. Based on what I've been reading, so all the files need that same column/item in order for there to not be errors? 

[milenahiggins]

Posting this in case it helps someone else in a similar situation. I had this error when loading a group of json files from a SharePoint folder. The issue turned out to be that one of my 50+ files was empty, so there indeed was no column, but just in that one file. Troubleshooting that was a real head-scratcher. I ended up creating another folder and copying just a few of the files into it and loading that worked perfectly. So I had to narrow it down to the bad file essentially by process of elimination. In hindsight, I could have also looked at the file sizes to figure out one was empty.

[Anonymous]

Tnks a lot! I had exactly the same issue, that was kindda weird for me having a Sharepoint datasource but geting a OLE ODBC error. Tnks

[See_Mun]

It works! Thank you! 

S

[ChandrashekaraD · Accepted solution]

Please check in your source data file, deleted one column

Due to that your getting that error