Hello,
I am getting an issue where im prompted with:
“The Microsoft Access database engine could not find the object ‘C:\Users\name\Downloads\test.xlsx’. Make sure the object exists and that you spell its name and the path name correctly. If ‘C:\Users\name\Downloads\test.xlsx’ is not a local object, check your network connection or contact the server administrator.”
This only happens when I try to call an SQL command in the “file open”. without this step I can run my method successfully.
Anyone knows what the error prompt means and what I am missing?
Hi,
For some reason my screen capture did not post here. Adding some additional pictures of trace + method without SQL and with (without works).
Some more background: I am creating a hit pick based on xlsx. file import. The issue im trying to work around arises when I want to use the following SQL command:
“SELECT * FROM [fileplaceholder.xlsx] WHERE [Volume] > 10”
I followed this as precisely as I could trying to use concat, replace and getfilename to work around that I have variable file names (opened from a dialogue).
Original protocol:
Thanks for the screenshots. It looks like your FROM references the file name. For XLSX files you use the sheet name that you are reading. So your SQL should look like:
I understand. Is there a way to access a sheet name or would the sheet name always have to be the same? I would probably just name it Sheet1 as it is the standard when creating xlsx files if its not doable.
Unfortunately, there isn’t an easy way to grab the sheet names from an Excel file in Venus. Typically, you would use fixed values for this such as Sheet1 as you mentioned.
Usually, we recommend using a text-based file instead for an input, as this eliminates the risk of a sheet being improperly named. This being said, xlsx files work just fine.
