"dotNET learner" <email@hidden> wrote in message
news:O79FLxkeHHA.1868@TK2MSFTNGP04.phx.gbl...
>I could successfully upsize all TABLES of an Access2002 database to
>SQLEXPRESS.
>
> How can I export/upsize Access Queries (which are many and useful)??
>
> Newbie seeks help.
>
> Thanks !
>

"Sylvain Lafontaine" <sylvain aei ca (fill the blanks, no spam please)>
wrote in message news:O2jjUhleHHA.4636@TK2MSFTNGP03.phx.gbl...
> The SQL Server Migration Assistant for Access (SSMA-Access) will do a
> better job than the Access Upsizing Wizard for upsizing queries.  However,
> for a lot of them, you will have to do the job yourself using the SQL
> Server Management Studio (SSMS, come with SQL-Server 2005) or the SQL
> Server Management Studio Express (SSMSE, for SQL-Server 2005 Express,
> free).
>
> SSMA-Access:
> http://www.microsoft.com/sql/solutions/migration/access/default.mspx
>
> SSMSE:
> http://www.microsoft.com/downloads/details.aspx?FamilyID=C243A5AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en
>
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
> E-mail: sylvain aei ca (fill the blanks, no spam please)
>
>
> "dotNET learner" <email@hidden> wrote in message
> news:O79FLxkeHHA.1868@TK2MSFTNGP04.phx.gbl...
>>I could successfully upsize all TABLES of an Access2002 database to
>>SQLEXPRESS.
>>
>> How can I export/upsize Access Queries (which are many and useful)??
>>
>> Newbie seeks help.
>>
>> Thanks !
>>
>
>

"dotNET learner" <email@hidden> wrote in message
news:O79FLxkeHHA.1868@TK2MSFTNGP04.phx.gbl...
> I could successfully upsize all TABLES of an Access2002 database to
> SQLEXPRESS.
>
> How can I export/upsize Access Queries (which are many and useful)??
>
> Newbie seeks help.
>
> Thanks !
>
>