Facing difficulty to insert excel data to database. pls help

Help Studio
, ,
1

Iam doing bulk insert to to Database but throwing error
image

2

@Lokesh_M2

When you do bulk insert…each column name and the datatype of the column should be same as the database columns…please check them
Properly

Cheers

3

Hi Anil This is the dat iam trying to inserting

Message ID Hotel Reference Your Reference Hotel Name Guest Name Arrival date Room Nights Stay TaxesFees Meal plan Rate break down
AS8PR08MB726833388CBEBF97DA0BF9@AS8PR08MB7268.eurprd08.prod.outlook.com 632E024143
 AR935456152 / 1
Hotel Manchester Central
 MRS Arsons 19-Apr-2013
 1 1 GBP86.00
 PER NIGHT STARTING 18 APR FOR 1 NIGHT GBP86.00 SUB
TOTAL FOR STAY GBP86.00
APPROX TOTAL INCL ALL KNOWN TAXES/FEES GBP86.00
4

Please check is there any spaces before and after column headers on excel

5

@Lokesh_M2

What are the column types in your database?

Thse column types and those should be matchinng…and column names also…even a extra space cannot be there

Cheers