We help IT Professionals succeed at work.

How to export an access database that is "too large"

I am exporting an access database within access. By > right clicking the database >export > ODBC database > Naming it > Choosing "Machine Data source" > Choosing my data source that I set up with ODBC

Then I get a pop up message stating  "Record is too large"

If there is a work around for exporting larger access databases to SQL Server please let me know.

Thanks!
Comment
Watch Question

Scott McDaniel (EE MVE )Infotrakker Software
Most Valuable Expert 2012
Top Expert 2014

Commented:
How large is your database?

First thing is to try compacting the database. This can sometimes shrink the database to a size you can work with.

If not, then you can export specific tables, which should get you under any limitations.

You might also do this the other way around, and use SQL Server Management Studio to import the Access database.
President / Owner
Fellow 2019
Most Valuable Expert 2017
Commented:
You should download and use SSMA (SQL Server Migration Assistant):

http://www.microsoft.com/en-us/download/details.aspx?id=42656

 Gives you a lot more control over the process of moving the data.

Jim.
Jim Dettman (EE MVE)President / Owner
Fellow 2019
Most Valuable Expert 2017

Commented:
By the way "Record too large" generally is an error on the receiving end indicating that it can't store the record that is being specified.

Are you combing data on the way out?

Jim.
melfrancineBusiness Process Solutions Manager

Author

Commented:
I used the 32 bit  SQL server migration assistant for access and it did the job perfectly. I was manually exporting tables from access to ODBC & sql server.