How to import data from CSV 2nd worksheet in SQL using bcp

See more:

SQL-Server

BCP

Hi coder,

I have to import data from excel (CSV) format into SQL server Database.
I know how to import csv file in db using bcp but only for one worksheet I want to import data of the second work in single query.

Create table test (customer_id int,telephone nvarchar(20))
DECLARE @CMD varchar(200)
SET @CMD='BCP db.dbo.test IN "Filepath" -S server details -T -f -t, -c -E'
EXEC Master..XP_CMDSHELL @CMD

Using the above code I am able to load the data from 1st worksheet of excel which is in CSV format but I also want to create second table and load the data of second worksheet into database in same query.

Any suggestions !!!

What I have tried:

<pre lang="text">Create table test (customer_id int,telephone nvarchar(20))
DECLARE @CMD varchar(200)
SET @CMD='BCP db.dbo.test IN "Filepath" -S server details -T -f -t, -c -E'
EXEC Master..XP_CMDSHELL @CMD