Access to SQL2000

What is the best way to import or transfer a Access database
to sql2000, I tried that wizard and for the life of me I cannot get
it to work correctly.

TIA

Michael

Please answer in the newsgroups so that others may see thie
information also.On Sat, 29 Nov 2003 07:05:35 -0500, "Michael, "
<ptbarnum@.nycap.rr.com> wrote:

>What is the best way to import or transfer a Access database
>to sql2000, I tried that wizard and for the life of me I cannot get
>it to work correctly.
>TIA
>Michael
>Please answer in the newsgroups so that others may see thie
>information also.|||"Michael, " <ptbarnum@.nycap.rr.com> wrote in message
news:5o2hsv84fvtgb11ifl5smh3fqr28qkbu7f@.4ax.com...
> What is the best way to import or transfer a Access database
> to sql2000, I tried that wizard and for the life of me I cannot get
> it to work correctly.
> TIA
> Michael
> Please answer in the newsgroups so that others may see thie
> information also.

Your best bet would be to use DTS. Is that what you mean by wizard? If so,
what is the failure specifically?

--
BV.
WebPorgmaster - www.IHeartMyPond.com
Work at Home, Save the Environment - www.amothersdream.com