Excel Datasource – Importing Duplicate Rows
Mick asked 2 years ago
I have created a Map with a custom eConnect Stored Procedure to import an excel spreadhseet.
The issue is when duplicate rows exist in the file, the second duplicate row doesn’t Import.
It appears the Key Fields selection excludes the duplicated row.
is there a way to have all the data imported into the SQL Data Table.
I have attpemted using the Excel Data Source, and creating an Excel ODBC Connection and selecting for the work sheet.
I tried to add a Row Number to the query, but this doesn’t appear possible for excel queries.
Thanks,
Mick
The issue is when duplicate rows exist in the file, the second duplicate row doesn’t Import.
It appears the Key Fields selection excludes the duplicated row.
is there a way to have all the data imported into the SQL Data Table.
I have attpemted using the Excel Data Source, and creating an Excel ODBC Connection and selecting for the work sheet.
I tried to add a Row Number to the query, but this doesn’t appear possible for excel queries.
Thanks,
Mick