Upsizing wizard error - The table was skipped, or export failed but works on access template db

I am using the upsize wizard from Access 2000 database to SQL Server 2000.  When I try upsizing the DB from my client the report I get back just says "The table was skipped, or export failed."  I am running under Windows 2000 Professional OS, Office 2000 Premium.   I can import from the client’s DB from a SQL DTS but want to use the Access upsizing tool.

I even installed all the items from the article http://support.microsoft.com/kb/272384#kb1   except the  files ACWZ_Admin.msp and MDT2_Admin.msp which give errors when applying the update patch that the program is not installed or incorrect version.

If I use a template DB created from Access like expenses it all upsizes OK.


AGHH!
HometownCompAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

flavoCommented:
Does the table have a PK?
HometownCompAuthor Commented:
how can I tell?
HometownCompAuthor Commented:
Some tables have primary keys.  I even tried creating a new table and that will not go up either.  I get the same error. - "The table was skipped, or export failed"
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

Leigh PurvisDatabase DeveloperCommented:
I'm puzzled by the line
"I can import from the client’s DB from a SQL DTS but want to use the Access upsizing tool."

Why don't you want to use the powerful and very often more reliable method of upsizing?
HometownCompAuthor Commented:
Is the more reliable method using DTS in Enterprise Mgr. to import into SQL 2000, adding in the pks which SQL doesn't seem to bring in ? (although I would just use SQL query analyzer to script any changes)
Leigh PurvisDatabase DeveloperCommented:
To my mind, upsizing is such an important task that I don't mind manually verifying the PK's afterwards.
I want to make sure that everything is spot on.

I suppose if you wanted - you could do it in advance offsite in development - and then generate the script to create the SQL database, run that at your client's office and use DTS to just import the data from the client's mdb - nothing more.

Then you're not spending lots of time onsite faffing about.
HometownCompAuthor Commented:
OK. then It looks like I will import using SQL DTS, then write scripts to create pks, build the database thru script, and then import the data.  Thoughts?

Any comments on when importing tables with the Access text type SQL autochanges them to nvarchar (2 bytes ) instead of the varchar (1 byte unicode) ?   They can just be left in the nvarchar type.  Thoughts?
Leigh PurvisDatabase DeveloperCommented:
Well - once you've done a test upsize - you can add the PK's through Enterprise Manager.
Once you're happy - let it generate a script to create the database - and then all you have to do is run that at your clients - and then run DTS to import the data.

As for nvarchar - it's just Unicode support.
If you have no need at all for the extended set that is permitted then you don't need it.
Many people use them though.  (Many don't too ;-)

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.