can i import my Access queries into SQL Server, i've tried and all it does is create new tables with the data form the queriescan i import my Access queries into SQL Server, i've tried and all it does is create new tables with the data form the queries
I'm assuming you want the query created as a view in sql server.
Go the the SQL view and cut and paste the DML in to query analyzer...you may need to modify it some.
Post the code here so we can have a look.|||The reason you may need to modify it is because Access SQL syntax is not exactly the same as MSSQL syntax.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment