Hi
I am trying to importing the Access Tables and Queryes to Sql Server But I cannot eable to Import the Queryes. What could be the reason.
Should I make the queryes as some seperate format?
Please Help me.
Printable View
Hi
I am trying to importing the Access Tables and Queryes to Sql Server But I cannot eable to Import the Queryes. What could be the reason.
Should I make the queryes as some seperate format?
Please Help me.
Not too sure what you're trying to do with the queries; but I assume you are trying to import the SQL, since the data itself is stored in the other tables, and the query is just a view on this data...
I don't think you'll be able to import the SQL, you may just have to use good old Copy and Paste to create new views and paste the SQl into them - not too bad if you don't have too many, a real pain if you have a lot (you could probably write a fairly simple piece of code to do it though...).