baskaran chellasamy

baskaran chellasamy

  • NA
  • 114
  • 146.4k

cannot able to convert ms access database to sqlserver

May 13 2013 5:18 AM
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