I have many access 97 databases I am trying to put into
SQL. From what I can find, Upsizing the database seems to
be less work in the long run, but I get the "overflow
error", microsoft has an article on this, which says to
use SQL server 7, then convert it into 2000. I do not have
a copy of SQL server 7. Is upsizing a lost cause? should I
just use DTS? Any help would be greatly appreciated!
Thanks!

My personal preference is to use DTS. Upsizing always seems to blow up in
strange places for me. And...while in development I frequently wind up
refreshing data via the packages from teh Access source tables. Easier to
executea DTS package than re-run the wizard.

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm
www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

"Matt" <anonymous (AT) discussions (DOT) microsoft.com> wrote