We are trying to import the data in to table. 0 is getting inserted in the primary key column. What is the exact procedure / steps to be followed for excel import for bulk insert in to master tables.

Hi there!

You will find documentation about importing data from Excel here.

Cheers!

You need to set the 'IsAutonumber' property of the Id field to Yes.

Hope this helps,
Curt