Iam doing bulk insert to to Database but throwing error
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
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 |
Please check is there any spaces before and after column headers on excel
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
Anil_G
raja.arslankhan
Shivam_Rana
u322805
Sathish_Kumar_S
Arvind_Kumar1
Camila_Caldas