Inserting Data into Excel

Sure, here's a clearer and more structured version of your text:

Hi Everyone,

I have a requirement involving two tables:

1. Tyre Data Table:

   • Columns: TyreID (Primary Key), PartNumber (Foreign Key)

2. Country Restriction Table:

   • Columns: ID (Primary Key), PartNumber (Foreign Key), Country Name, IsActive (Boolean)

These tables have a one-to-many relationship. For example, if we have a tyre with TyreID 1, there could be 150 entries in the Country Restriction Table for this tyre. Let's say for TyreID 1, it is active in India and the US. In this case, the IsActive column would be 1 for India and the US, and 0 for all other countries(all remaining rows).

Export Requirement:

We need to export the data in the following format: