Unanswered: Upsizing from Access and Default Values
I'm using the upsizing wizard in Access 2000, but the default values in my Access tables don't seem to be transferring to my SQLServer tables. Everything else seems to be working fine, just not the default values...
Please let me know if you've experienced a similar problem, or if you know of a solution to this issue.
Oops, turns out it wasn't a bug, but a careless mistake on my part. I was using the export table function, rather than the upsizing wizard. If I use the upsizing wizard, and make sure to specify include defaults, then everything works as it should.
I've attached a link to a screen shot showing the dialog with the include defaults option, just in case anyone else is as obtuse as me .