June 14, 2012 at 1:52 pm
I have tried to use import tool within MSManagement studio to copy all tables and it worked fine. However, It copied all veiwes and placed them into the table section instead of veiw. Please assist.
KInd Regards.
June 15, 2012 at 7:36 am
Do you mean saved queries? Access doesn't have views.
June 15, 2012 at 8:50 am
Yes, I meant saved queries.
June 15, 2012 at 8:56 am
That is what that import tool does. It would be nearly impossible to convert the actual sql automatically. If you want to convert it to a view you will have take the sql from the Access query and write it as a create view statement.
_______________________________________________________________
Need help? Help us help you.
Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.
Need to split a string? Try Jeff Modens splitter http://www.sqlservercentral.com/articles/Tally+Table/72993/.
Cross Tabs and Pivots, Part 1 – Converting Rows to Columns - http://www.sqlservercentral.com/articles/T-SQL/63681/
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs - http://www.sqlservercentral.com/articles/Crosstab/65048/
Understanding and Using APPLY (Part 1) - http://www.sqlservercentral.com/articles/APPLY/69953/
Understanding and Using APPLY (Part 2) - http://www.sqlservercentral.com/articles/APPLY/69954/
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply