# Export to Database Error

**URL:** <https://community.easymorph.com/t/export-to-database-error/5075>\
**Category:** Support\
**Created:** [December 18, 2023, 2:45pm UTC](https://community.easymorph.com/t/export-to-database-error/5075 "2023-12-18T14:45:22Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![nicktagz](https://community.easymorph.com/user_avatar/community.easymorph.com/nicktagz/32/5816_2.png) [@nicktagz](https://community.easymorph.com/u/nicktagz)\
**Post date:** [December 18, 2023, 2:45pm UTC](https://community.easymorph.com/t/export-to-database-error/5075/1 "2023-12-18T14:45:22Z")

</div>

I'm trying to Export to database, SQL database, and I get this error if I try to export more than 1 record at a time. Currently on version 5.6.1.12

Error: Export of batch with rows #1-10 failed with the following error: Parse error at line: 1, column: 635: Incorrect syntax near ','.

---

<div class="post-metadata">

**Author:** ![andrew.rybka](https://community.easymorph.com/user_avatar/community.easymorph.com/andrew.rybka/32/13_2.png) [@andrew.rybka](https://community.easymorph.com/u/andrew.rybka)\
**Post date:** [December 18, 2023, 3:55pm UTC](https://community.easymorph.com/t/export-to-database-error/5075/2 "2023-12-18T15:55:38Z")

</div>

What database are you exporting to, and which connector are you using - native or ODBC?

---

<div class="post-metadata">

**Author:** ![nicktagz](https://community.easymorph.com/user_avatar/community.easymorph.com/nicktagz/32/5816_2.png) [@nicktagz](https://community.easymorph.com/u/nicktagz)\
**Post date:** [December 18, 2023, 4:11pm UTC](https://community.easymorph.com/t/export-to-database-error/5075/3 "2023-12-18T16:11:51Z")

</div>

I'm using the SQL Server connector for EM.

Dedicated SQL Pool in Azure.

 ![image](https://community.easymorph.com/uploads/default/original/2X/c/c526282a5d48ebac57cf11991edaf9d4b81b2a7a.png)

---

<div class="post-metadata">

**Author:** ![andrew.rybka](https://community.easymorph.com/user_avatar/community.easymorph.com/andrew.rybka/32/13_2.png) [@andrew.rybka](https://community.easymorph.com/u/andrew.rybka)\
**Post date:** [December 18, 2023, 4:21pm UTC](https://community.easymorph.com/t/export-to-database-error/5075/4 "2023-12-18T16:21:44Z")

</div>

It seems that Azure Synapse Analytics doesn't support the insertion of several rows with a single INSERT command. So the "Export to database" action will have to export rows one by one.

---

<div class="post-metadata">

**Author:** ![nicktagz](https://community.easymorph.com/user_avatar/community.easymorph.com/nicktagz/32/5816_2.png) [@nicktagz](https://community.easymorph.com/u/nicktagz)\
**Post date:** [December 18, 2023, 4:30pm UTC](https://community.easymorph.com/t/export-to-database-error/5075/5 "2023-12-18T16:30:09Z")

</div>

> [@andrew.rybka](#):
>
> It seems that Azure Synapse Analytics doesn't support the insertion of several rows with a single INSERT command.

Thank you.

Does EM use an insert select or insert values statement?

---

<div class="post-metadata">

**Author:** ![andrew.rybka](https://community.easymorph.com/user_avatar/community.easymorph.com/andrew.rybka/32/13_2.png) [@andrew.rybka](https://community.easymorph.com/u/andrew.rybka)\
**Post date:** [December 18, 2023, 4:31pm UTC](https://community.easymorph.com/t/export-to-database-error/5075/6 "2023-12-18T16:31:48Z")

</div>

You are welcome!

EM uses the insert values statement.