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 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.

importing a table from access

I have an access database that i upsized a few weeks ago and i need to add another table form that database, however when i use the DTS import wizard to get the particular table i wish i get as far as picking the table but i cant preview or do the import, i get the following error message on it!

Error Source: Microsoft Jet Database, Error Description: record(s) cannot be read; No permission on the table 'InternetBilling', Context: error calling openrowset on the provider.

Ive working on a copy of the access database and given all user groups read persmission and im still getting this, how do i get around it?

With much thanks for any help,

Amit

Is the file workgoup file secured ? Then you have to use name the workgroup file in the properties of the data source, otherwise the server can′t authenticate at access.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de