I checked the view in sql server but i don’t see any user created view i can only see system views. There were 8 queries and 2 of them were...

below are the queries which errored out--- I changed the distinctrow to distinct and as function to Function_1 and that corrected the syntax and after these changes the query...

Thank you so much all for your help and support ...You guys helped me al ot

Thank you so much PaulB and Corgi for your quick response. When I try to migrate through SSMA it converts everything except 2 queries and in the...

Thank you so much WILLIAM ! That worked !!

Thank you so much for your quick response.

When I tried to connect to access db via import/export it gives me three options

Access db file path -- I know the...

Thank you so much robinrai3 ! it was really helpful. I just want to try different options to migrate from MS Access to SQL server and that’s why I am...

Thank you so much Paul for your quick reply.... I've just started learning tsql and I am not sure how to add my logic in the script..could you please help...