This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Good Day all,
I have been trying to migrate an Access 365 Database to SQL server 2019, all 64bit. it will read the tables just fine. but when I choose tables to move I get this error/notice: "Operation Prerequisites Not Met" dialog box comes up. The following list of tables violated some prerequisites: Do you want to continue?
The First column is Status with red X in it.
Second column "Name", the name of the table (which are AbstPay, CheckNumber_Date, and Clients.
Third column Messsage: The table 'RLOData2SQL004.dbo.[the table name]' does not exist is target. You must first convert the table and then load it into the database.
What does this mean? I would like very much to get this database moved to SQL Server 2019
A family of Microsoft relational database management systems designed for ease of use.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Step one. HOW have you been trying to perform this migration? SSMA perhaps?
Do any of the tables contain attachment fields, Multi-Value fields, or Look up fields? They can not be migrated.