Hi Guys,

I am trying to convert access 97 database to SQL server. Can you anyone help
on this?

Any help is appreciated...

thanks,
Hasi

Unlike the Upsizing Wizard that comes with Access 97, which only works with
the older versions of SQL-Server, the SQL Server Migration Assistant for
Access (SSMA - Access) is probably capable of upsizing it to the version of
SQL-Server that you're using:

http://www.microsoft.com/sqlserver/2...on-access.aspx

Trying to automatically upsize a database is not always an easy task and
often, it's more easier to simply do it by hand. In almost every case,
you'll have to finish the job by hand, anyway.

There are two ways of upsizing an Access database: toward a MDB (or ACCDB
file in the case of Access 2007) with ODBC linked tables or toward an Access
Data Project (ADP). This newsgroup is about ADP, so if your intention is to
use ODBC linked tables, another newsgroup might be more appropriate than
this one.

--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: sylvain aei ca (fill the blanks, no spam please)


"Hasi" <(E-Mail Removed)> wrote in message
news:C504830D-FA4A-4072-82E1-(E-Mail Removed)...
> Hi Guys,
>
> I am trying to convert access 97 database to SQL server. Can you anyone
> help
> on this?
>
> Any help is appreciated...
>
> thanks,
> Hasi

Hi,

Can you please suggest what group should I be contacting?

thanks for your help and advice.

"Sylvain Lafontaine" wrote:

> Unlike the Upsizing Wizard that comes with Access 97, which only works with
> the older versions of SQL-Server, the SQL Server Migration Assistant for
> Access (SSMA - Access) is probably capable of upsizing it to the version of
> SQL-Server that you're using:
>
> http://www.microsoft.com/sqlserver/2...on-access.aspx
>
> Trying to automatically upsize a database is not always an easy task and
> often, it's more easier to simply do it by hand. In almost every case,
> you'll have to finish the job by hand, anyway.
>
> There are two ways of upsizing an Access database: toward a MDB (or ACCDB
> file in the case of Access 2007) with ODBC linked tables or toward an Access
> Data Project (ADP). This newsgroup is about ADP, so if your intention is to
> use ODBC linked tables, another newsgroup might be more appropriate than
> this one.
>
> --
> Sylvain Lafontaine, ing.
> MVP - Technologies Virtual-PC
> E-mail: sylvain aei ca (fill the blanks, no spam please)
>
>
> "Hasi" <(E-Mail Removed)> wrote in message
> news:C504830D-FA4A-4072-82E1-(E-Mail Removed)...
> > Hi Guys,
> >
> > I am trying to convert access 97 database to SQL server. Can you anyone
> > help
> > on this?
> >
> > Any help is appreciated...
> >
> > thanks,
> > Hasi
>
>
>

How about microsoft.public.access.sqlupsizing?

http://www.microsoft.com/communities...ss.sqlupsizing

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)


"Hasi" <(E-Mail Removed)> wrote in message
news:7CC5EC00-A8E6-494B-AEB5-(E-Mail Removed)...
> Hi,
>
> Can you please suggest what group should I be contacting?
>
> thanks for your help and advice.
>
> "Sylvain Lafontaine" wrote:
>
>> Unlike the Upsizing Wizard that comes with Access 97, which only works
>> with
>> the older versions of SQL-Server, the SQL Server Migration Assistant for
>> Access (SSMA - Access) is probably capable of upsizing it to the version
>> of
>> SQL-Server that you're using:
>>
>> http://www.microsoft.com/sqlserver/2...on-access.aspx
>>
>> Trying to automatically upsize a database is not always an easy task and
>> often, it's more easier to simply do it by hand. In almost every case,
>> you'll have to finish the job by hand, anyway.
>>
>> There are two ways of upsizing an Access database: toward a MDB (or ACCDB
>> file in the case of Access 2007) with ODBC linked tables or toward an
>> Access
>> Data Project (ADP). This newsgroup is about ADP, so if your intention is
>> to
>> use ODBC linked tables, another newsgroup might be more appropriate than
>> this one.
>>
>> --
>> Sylvain Lafontaine, ing.
>> MVP - Technologies Virtual-PC
>> E-mail: sylvain aei ca (fill the blanks, no spam please)
>>
>>
>> "Hasi" <(E-Mail Removed)> wrote in message
>> news:C504830D-FA4A-4072-82E1-(E-Mail Removed)...
>> > Hi Guys,
>> >
>> > I am trying to convert access 97 database to SQL server. Can you anyone
>> > help
>> > on this?
>> >
>> > Any help is appreciated...
>> >
>> > thanks,
>> > Hasi
>>
>>
>>