Import from Access .accdb file to SQL Server
I've had to import Access files into SQL Server before and haven't found the Import and Export wizard to be a very good tool for the job. What I ended up doing was opening up the Access file, finding the table, right clicking and going to Export -> ODBC Database. This does require you to have a User or System DSN setup for the target SQL Server database, and it is a bit slow, but it was the only thing that I found that worked all that well. (It will create the target table for you.)