User-664080073 posted
Hi,
I have an xlsx file with data like
Car door electric contacts or car door interlocks |
Hydraulic |
Car |
Monthly |
And having around 65 rows
I want to bulk insert this data to a table having following rows
TaskCategoryID, TaskTypeID, Name, MinMinutes, MaxMinutes, CreatedDate, CreatedBy, IsDeleted, RecommendNotifyPeriod, EquipmentTypeId, FrequencyID, EquipmentContractName
But TaskCategoryID,TaskTypeID, FrequencyID are all foreign keys.
How could I use bulk insert to insert the data or is it better to insert normally through insert query.
Thank You in Advance.