Excel Tools

Hi All,

Can't we import only a specific columns from csv to database.

Requirement:

I have a csv with 10 Columns, out of which I want to import only 5 column into the database.

ColumnNames property in the import csv to DB plugin is not working it seems.

Any inputs?

Thanks in advance.

Unfortunately, this isn't currently an option.  Typically this handled by having a staging table that takes in all of the columns and then running a stored procedure to transfer from the staging table to the actual table.

Unfortunately, this isn't currently an option.  Typically this handled by having a staging table that takes in all of the columns and then running a stored procedure to transfer from the staging table to the actual table.