Import Queries to Access Project

[millard.fillmore.13]

I have a database that was built in a traditional Access 2003 mdb file.
I am trying to convert it to an Access "Project" .adp file.

I created a new project and successfully connected with the SQL server.
I was able to import my tables, forms, macros, and modules.

The queries, however, don't show up when I try to import data. Can
someone tell me what I need to do to import queries from an mdb into an
adp connected to SQL Server 2000?

Thanks!

 

[Sylvain Lafontaine]

The Upsizing Wizard is not able to import many types of query into
SQL-Server; however, it should have imported some of them at least.

I'm afraid that you will have to rewrite them into the SQL-Server database.

You may to try the new Access to SQL upszing tool which is available on
http://www.microsoft.com/sql/solutions/migration/default.mspx

however, as I neved used it myself, I don't know if it's capable of
importing your queries to SQL-Server.

 

[millard.fillmore.13]

Thanks... I'll give it a try!

The Upsizing Wizard is not able to import many types of query into
SQL-Server; however, it should have imported some of them at least.

I'm afraid that you will have to rewrite them into the SQL-Server database.

You may to try the new Access to SQL upszing tool which is available on
http://www.microsoft.com/sql/solutions/migration/default.mspx

however, as I neved used it myself, I don't know if it's capable of
importing your queries to SQL-Server.