Upsizing Wizard skips table

• Steve Spicer-470948

  Newbie

  Points: 2

  More actions

  July 30, 2007 at 5:51 am

  #70585

  I've been trying to Upsize an Access2003 database to SQL Server Express. It transfers the structure fine, but no data. It's a very simple database I created for testing, but the Upsizing Wizard in Access fails everytime to transfer any data. It creates a .mdf file of 1,216 KB - opens the .adp file in Access which shows the structure, but no records and says it skipped the table. There are only four fields...a Primary Key ID, Name, FirstName and LastName. I've been beating my head on this one. Any help would be appreciated.

  Thanks,

  Steve

• Perry Harts

  Ten Centuries

  Points: 1271

  More actions

  July 30, 2007 at 9:05 am

  #723323

  Microsoft has SQL Migration Assistant at http://www.microsoft.com/sql/solutions/migration/access/default.mspx .  I have better success with it than the wizard.

• Steve Spicer-470948

  Newbie

  Points: 2

  More actions

  July 31, 2007 at 3:46 am

  #723515

  Thanks very much Perry....great tool that worked. Another baby step....

  Steve