# Insert Statement Generation

Transforms can automatically generate an MSSQL insert statement from an input file. This is handy when you can't directly load data in, or only have a query window to work from. You can find the under the "PREPARE" tab -> Utils menu.

<figure><img src="https://2203366127-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FloJjRj49SSQfSrp7vuw9%2Fuploads%2FHNnQj5BWyYi9Ft245Dwg%2FTransformsINSST.jpg?alt=media&#x26;token=3ee65fef-b675-4729-8a70-6498802bf62f" alt=""><figcaption><p>Insert Generator</p></figcaption></figure>

### Utils Menu

To generate an insert statement, head over to the Utils section. You'll find the file upload, and generation methods there.&#x20;

The NVarchar option will generate all strings as `N''` -  Enabling NVarchar type inserts.&#x20;

Once a file has been supplied, simply click "Get Script" to download the `.sql` file.&#x20;

{% hint style="warning" %}
Don't forget to change the insert table name, as it's assumed by the filename (not known at generation time!)
{% endhint %}