Database Proccess Query Step

Hello, I tried and it worked using the same data and query.

Could you please check the following:

• Do you have a suitable OLE DB driver installed on your machine?
• Is your connection string correct? It should look like this:

Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Robotiq\excel.xlsx;Extended Properties=”Excel 8.0;HDR=YES”;

Remember to replace C:\Robotiq\excel.xlsx with the full file path of your Excel file.

• Does your Excel file have the .xlsx extension?
•  How are your columns formatted in Excel? In your query, the columns “naziv” and “FINA ID” should be formatted as text. It’s possible that the “FINA ID” column is formatted as a number.

Hi,

No, I checked all of this:

-Do you have a suitable OLE DB driver installed on your machine?
– Is your connection string correct? It should look like this:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Robotiq\excel.xlsx;Extended Properties=”Excel 8.0;HDR=YES”;
– Does your Excel file have the .xlsx extension?
– How are your columns formatted in Excel? In your query, the columns “naziv” and “FINA ID” should be formatted as text. It’s possible that
the “FINA ID” column is formatted as a number.

Issue is the same. There’s no error but nothing is done.

Kind regard,

Vanja