Exporting CLOB to SQL Server from Access

Question

I have an Access table that has a Memo field that's about 217,000 characters.

When I try to update the SQL Server table, the connection breaks. Rows with <180,000 characters in the CLOB are not an issue. Is this maybe a timeout issue? Can I reset the max time on transaction for the ODBC connection to fix this?

Thanks,

Jnana

---

Jnana Sivananda

Answer 1

Hi Jnana,

For this issue, export data from Access to SQL Server, I would like to suggest you to post this thread to Access forum for more support, because it is related to the configuration in Access side.

In ordinary, if you want to export data to SQL Server, you can use SQL Server Import and Export Wizard, which provides the simplest method of copying data between data sources and of constructing basic packages.

For more information, please see: http://msdn.microsoft.com/en-us/library/ms140052.aspx

---

Best Regards,
Iric
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

SQL Server 2008R2 only recognizes .mdb format for Access, so you can't use the import/export wizard for .accdb databases.

And SSMA wasn't letting the big records through.

Thanks anyway.

Jnana

---

Jnana Sivananda

Answer 3

Jnana,

So, here is the Access forum address:

http://social.msdn.microsoft.com/Forums/en-us/accessdev/threads

Please post the thread here and get more support.

---

Best Regards,
Iric
Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 4

Hello,

I followed the advice of Iric and i have done the move.

I hope you will find a quick and full answer on this forum.

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.