Hi,
I have got some errors while migrating Access to SQL Server Express 2005 via
SSMA for Access.
The following is the error
Message:
A2SS0058: SQL Server Migration Assistant for Access Error message: SQL
statement is not supported.
Description:
SELECT PSQuery.FO_Order, Projects.Project_Name, Projects.PS_ID,
Projects.[Project Code], Projects.Proj_ID, PSQuery.System_Name,
PSQuery.PN_ID, Projects
FROM (PSQuery INNER JOIN Projects ON PSQuery.PS_ID = Projects.PS_ID) INNER
JOIN [CHW Job] ON Projects.J_ID = [CHW Job].J_ID
GROUP BY PSQuery.FO_Order, Projects.Project_Name, Projects.PS_ID,
Projects.[Project Code], Projects.Proj_ID, PSQuery.System_Name,
PSQuery.PN_ID, Projects.J_ID, [CHW Job].Job_Name
ORDER BY PSQuery.FO_Order, PSQuery.System_Name, PSQuery.PN_ID;
Is there any way of getting this query to work in SQL Server?
Thank you in advance
It seems to me that i
|