Microsoft Access to SQL Server 2005

Hi,

I have a database in MSACCESS 2003 that is 680MB (after compacting) and contains 41 tables.

I tried to import these tables to SQL Server 2005 (express edition) using the :"upsizing wizard" provided in MSACCESS. The wizard works fine but all the tables are not being imported to SQL Server (only 19 tables are getting imported) and the size of the database in SQL Server (the ".mdf file") is 1.03 GB (I have tried using the "shrink" option also) . Further, when I try to open one of the tables (which has 625295 rows and 90 columns) , it takes lot of time to display all records.

So, my problem is do I need to set any options for any of these above issues, I tried to look for any information regarding this but was unsuccessful.

Any help on this will be very much helpful for me!

thanks

Further, when I try to open one of the tables (which has 625295 rows and 90 columns) , it takes lot of time to display all records.

So filter the records by queries and never select so much data to client application ( I hasn't ever seen a user able to deal with such amount of data ), and all will be ok.

only 19 tables are getting imported

And there were no any error message during import?

".mdf file" is 1.03 GB

It is possible, that MSSQL requieres more space to store the data.

|||

Hi,

Thanks for the information

I see then, it is normal for SQL Server 2005 to take some amount of time to display all the records of a table, if the table is huge.

Regarding the import problem, I dont get any error while importing.I wonder why only 19 tables are getting imported (may be due to huge table I have in the database)