cannot able to convert ms access database to sql server database

See more:

SQL-Server

Hi friends
I have tried to convert ms access database to sql database.but i could not able to done it successfully. the below methods are i have been using so for
1.from sql server 2008 i created a empty database and try to import data from task but it shows

cannot start your application.the workgroup information is missing or open by another user.(microsoft jet database engine).

2. i try to convert through ssma, it encounters problem in add database from ms access.the error is

Retrieving the COM class factory for component with CLSID {CD7791B9-43FD-42C5-AE42-8DD2811F0419} failed due to the following error: 80040154. This error may be a result of running SSMA as 64-bit application while having only 32-bit connectivity components installed or vice versa. You can run 32-bit SSMA application if you have 32-bit connectivity components or 64-bit SSMA application if you have 64-bit connectivity components, shortcut to both 32-bit and 64-bit SSMA can be found under the Programs menu. You can also consider updating your connectivity components from http://go.microsoft.com/fwlink/?LinkId=197502.      An error occurred while loading database content.

3. I have check my system whether it contain mdac.by typing i

Regsvr32.exe "<<Dao360.dll_Path>>"

it show this module fail to load.and could not be found.

My question is

i am using windows 8 x64 processor. how can convert this ms access database to sql server database. please give me suitable answer. i tried with google in different manner.but i am not able to find the answer. please help me


Thanks in Advance