var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: importing from access to SQL Server
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 queries
I'm assuming you want the query created as a view in sql server.
Originally Posted by yan1
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.