Forum Discussion
error importing query
I created a query to a folder that contains 3 worksheets, all three have the same data types, my query would bring the data from the date column and the data from the column with values, the error occurs when importing the date data from worksheet 2, the query returns the dates of worksheets 1 and 3 and does not match the dates of worksheet 2. The setting is exactly the same. Can someone help me?
I'm using excel pro plus 2016 I'm using excel pro plus 2016
Hi Ricardo,
That usually happens if column names in files are not exactly the same. Like in this sample
I have "Date 2" with one space in between for the first file and with two spaces in between for the second file.
To be sure you may copy column names from first file and paste them to column names for the file in question.
5 Replies
Hi Ricardo,
It's hard to say what's wrong without seeing concrete files. Most probably something is wrong with the second file, not in settings. To be sure you may rename copy of first file and substitute it instead of second one. If works, you shall check the second file more carefully.
Hello Sergei,
Thanks for your return, I have refactored the spreadsheet and rename it, but it did not work, I made some prints of the query, notice that the query returns as null and where it should recognize how number it does not recognize, as I said, the spreadsheet is configured correctly.Hi Ricardo,
That usually happens if column names in files are not exactly the same. Like in this sample
I have "Date 2" with one space in between for the first file and with two spaces in between for the second file.
To be sure you may copy column names from first file and paste them to column names for the file in question.
