Import from Access accdb (1 Viewer)

[Pat Hartman]

I've never done this but it seems like I should be able to open ssms and import tables from an .accdb but I can't seem to find the right tool. I have SQL Server Express so maybe it doesn't exist.

I don't want to have to use ssma if I can do the conversion a different way.

 

[theDBguy]

How about right-click on the database and select Tasks > Import Data?

 

[isladogs]

Use the SQL Server Import/Export Wizard

 

[Isaac]

import/export wizard is a wonderful tool
and even has an option at the end to create a dtsx if that suits for future use

 

[Pat Hartman]

Thanks, I found it. Haven't gotten it to import anything yet but I'm working on it.