How to import my Access 2007 DB into SQL Server 2008?

The problem is that Access 2007 saves as .accdb and when I use the Import Data function in SQL server 2008, and select "Access"  as a datasource, its looking only for .mdb.  It doesn't recognize .accdb at all.  How do I get my Access 2007 into my SQL Server?
arthurh88Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jchapman99Commented:
one alternative - instead of using the Import Data function in SQL server 2008, you could use the Move Data function in Access 2007.  
first, create an ODBC connection for the SQL server database.  Then in Access, go to the Database Tools menu, and select Move Data (SQL Server).  

another alternative would be to save the access 2007 database as Access 2002-2003 format, so it would be an mdb file.

0
Chris LuttrellSenior Database ArchitectCommented:
From this link, http://msdn.microsoft.com/en-us/library/ms189667.aspx, to "Choose a Data Source (SQL Server Import and Export Wizard)" it refers to this link, http://msdn.microsoft.com/en-us/library/cc280478.aspx, for "How to: Connect to an Access Database" which tells you how to do it, the main line is below:
"On the Choose a Data Source page, for Data Source, select Microsoft Office 12.0 Access Database Engine OLE DB Provider, and then configure the connection as appropriate."

HTH, Chris
0
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
I'd suggest you use the SQL Server Migration Assistant: http://www.microsoft.com/Sqlserver/2005/en/us/migration.aspx

The link above is for SQL Server 2005; there's also one for 2008.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Chris LuttrellSenior Database ArchitectCommented:
P.S. to my comment above.  Unfortunately, it does not appear to have a browse feature to go find the file.  After picking the Microsoft Office 12.0 Access Database Engine OLE DB Provider, you have to click the properties link to put in the .accdb file name and password if any.  But the import worked perfectly from there.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.