Upsizing Access to SQL Server Express problem

[sgkurian]

Hello

Does anyone have any experience upsizing an Access 2007 database to SQL Server Express 2005 using the Upsizing wizard?

I keep getting the same error each time which is

'Table was skipped or Export Failed'

Could you please let me know if you know why I keep getting this error on the 'Upsizing Wizard Report'


Regards
Steven

 

[dhookom]

Are you using any unique field types? Can you tell us if upsizing a file with a few simple tables works?

Duane
Hook'D on Access
MS Access MVP

 

[sgkurian]

Hello Duane

I still keep getting this error when I try to upsize a new database with only a few basic tables (just a few text fields in each)

 

[Lilliabeth]

Any lookups in those tables?

--Lilliabeth

 

[dhookom]

Have you tried to simply export the table to a database in SQL server?

Duane
Hook'D on Access
MS Access MVP