Skip to main content
newtona0002
New Participant
Jul 24, 2024 2:47 PM UTC
Question

Data Issue in Import Excel To DB.

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

yogip3177
Brainy
Jul 24, 2024 4:22 PM UTC

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