Data migration from Access 97 to SQL server2000

[ppalani]

Hi,
I have a program done in full Access 97 with forms,querries,reports,macros. everything fully in Access97 mdb file. since because of database size its very difficult to continue. Is there anyway to migrate to SQLserver2000. if so any can give some sample codings. is there any way to migrate the datas from Access to SQL server. I know only Access to Oracle Datamigration and used to it.

waiting for sutable answer.
thanks in Advance.

[michelle]

Hello ppalani,

There is no source, you have to move the access database by hand to SQLserver2000.

Create in your SQLserver2000 a new database and goto the tables map of this database.

On the top of the form you will see "Tools", open this;
Use Data transmission services / import data;
Use the source: ms access, choose your database;
Check the right database;
Adter a view times next you will see the tables. Select what you need;
Next, you can run the import directly;

Good luck and if there are question we will try to answer you

Nice regards,

Michelle

[Briantcva]

The migration wizard works but you might be disapointed w/ the results (I was). If you have the time, might be better to design all your table in SQl Server (w/ the correct data types) and use the DTS wizard for the actual data.

[ppalani]

thanks for the replies.
I'll try this.
thanks once again.