SSMA for Access console issues

Greydog1 1 Reputation point
2021-04-10T02:57:08.413+00:00

I'm trying to use the latest release of SSMA (v8.18) console and am running into a problem with Access database names that contain spaces. This goes in the Variable Values file for the variable AccessDatabase. I am getting a FATALERR that it cannot parse the name. I have tried [] around the name and just got a different error saying the Access database was not found. Is there a workaround? I found this post ssma-for-access-console-issues but the proposed answer from 2 years ago says to use the current version. Any help out there?

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
547 questions
{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.