Sql-server – access 2003 to sql server 2008

ms accesssql-server-2008

I search a way to export an access 2003 database to sql server express 2008.

  • the export is on la (other computer than the server).
  • the computer have office 2003.
  • the computer doesn't have admin right (cant install things who needs admin)

access sql migration said that he cant(because 2008 is too new)

whats the better(easyer and shortway) to export the db?

Best Answer

You can use the Import/Export wizard with SQL Server. I came across a very good write-up (nice pretty pictures) here on it.