Forum Discussion
Jota_Q
Jul 04, 2024Copper Contributor
Import ACCDB to SQL SERVER
Hi... working with SQL SERVER MANAGEMENT STUDIO 20.1, I try to import accdb database, and it is impossible. It only allows me to import data from mdb databases. Any help please? Thanks in advanced!...
Jota_Q
Jul 05, 2024Copper Contributor
Hi. Thanks for response.
If I choose "Microsoft Access (Jet Database Engine)" only allow me to select MDB databases, if I select an ACCDB database i get the error "database format is not recognized".
On the other hand, option "Microsoft Office 12.0 Access Database Engine OLE DB Provider" does not appears in my list of choices.
If I choose "Microsoft Access (Jet Database Engine)" only allow me to select MDB databases, if I select an ACCDB database i get the error "database format is not recognized".
On the other hand, option "Microsoft Office 12.0 Access Database Engine OLE DB Provider" does not appears in my list of choices.
olafhelper
Jul 08, 2024Bronze Contributor
Jota_Q , if you want to use data provider like ACE, then you have to install it first.