Skip to main content
N
newtona0002
July 24, 2024
Question

Data Issue in Import Excel To DB.

  • July 24, 2024
  • 1 reply
  • 0 views

Hi, we are using import excel to db plugin to dump data from to excel to DB. It is reading the data from excel cell. But if the excel cell contains "- ", / "$" then the plugin removed the value from the content. 

For example:

  • Excel Cell Contains "Testing - Monday", then in staging table contains "Testing Monday"
  • Excel Cell Contains "Testing$", then in staging table contains "Testing".

Is anything we missed. Can anyone help on this.          

1 reply

Y
yogip3177
July 24, 2024

Maybe some issue with file encoding or any other issue. If you are still facing the same issue, attach a sample Excel file.

Terms & ConditionsAccessibility statement