Convert from MS Access to SQL Server database.

[yrf9320]

I have to convert MS Access database to a SQL Server database. Can anyone tell me how to do that. Shall I use DAO for it, or there is another way to do it.