question

Murali avatar image
Murali asked

how to import to SQLSERVER

Hi, I am using typical stand alone system in MS-Access, but for my company....who all are users all users are using client application and the database file (.MDF) I kept in Windows 2000 Server and i mapped the folder to client systems. Now presently my requirement is .... 1) Is it possible to install SQLSERVER2008 on Windows 2000 Server? 2) how to export the data from MS-Access file (.MDF) to SQL Server 2008 by using SSIS package. Any help pls....
sql-server-2008ssismicrosoft-accessupgrading-access-to-sql
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WilliamD avatar image
WilliamD answered
You cannot instal SQL 2008 on Windows 2000, you must use 2003 SP2 at least. [Link to requirements][1] As for importing the data, you don't need to export first, you should be able to use SSIS to connect directly to the access file and read the tables out. The drivers should be included by default, although I am not certain about 64 Bit drivers for Access. [1]: http://msdn.microsoft.com/en-us/library/ms143506.aspx
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

thank you for the info
0 Likes 0 ·
Fatherjack avatar image
Fatherjack answered
If I had this project I would certainly take a look at the Access Migration tool ( http://www.microsoft.com/sqlserver/2005/en/us/migration-access.aspx). It splits an access file into two, one file being the forms and reports and the other being the data objects which it then uses to create a SQL database. All via a wizard. Obviously the process can have some effects you dont want but I would recommend trying it on a copy just to see if it gets you 90% of the way... once you get the SQL Server installed of course..!
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

A similar question on migrating access to sql server: http://ask.sqlservercentral.com/questions/3262/migrating-access-to-sql
1 Like 1 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.