March 14, 2013 at 11:32 am
I am trying to import a .accdb file into SQL Server but do not see any option in SQL Server Import Wizard. There is an option of importing a .mdb file but not .accdb file.
Does anyone know how to import such a file to SQL 2008?
Thanks
KK
March 14, 2013 at 12:12 pm
Under Choose Data Source, use Microsoft Office 12.0 Access Database Engine OLE DB Provider - "Microsoft Access" is for Office versions lower than 2007
______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience
March 14, 2013 at 12:33 pm
Yes, that worked. Thanks!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy