Developer forum

Forum » PIM » Simple import in PIM

Simple import in PIM

Aki Ruuskanen
Aki Ruuskanen


I am trying to get a very simple product import from Excel to work. 

I have an Excel file with three columns. ProductLanguageID, ProductID and ProductName.

I click on the "Import products" in a product group in PIM.

I choose the Excel file and select "Excel" as "Source file type".

When clicking next I et the screen in the attached file "ExcelImport.png". It tells me to select source in the "Table / Sheet" field. But it's empty. 

What am I doing wrong?

Regards / Aki



Søren Jensen Dynamicweb Employee
Søren Jensen
This post has been marked as an answer

Hi Aki,

I have just tried to import your attached Excel file "ImportTest.xlsx", on my DW9.8 solution.

It works fine for Me.

If you still have problems, please contact support


Best regards



Votes for this answer: 1
Aki Ruuskanen
Aki Ruuskanen

I saw now that the OLEDB drivers are not installed on the server. Got that server error when I tried to create a regular Data Integration from Excel. 

I thought that it was because first I tried to export from PIM and the import the same file and the worked just fine.

Appearently that feature does not use the OLEDB to access the Excelfile. 


Aki Ruuskanen
Aki Ruuskanen

I can confirm that the problem was with the OLDDB drivers. yes

It was a very silent error though. Maybe some kind of error message would be good. 



You must be logged in to post in the forum