Importing data from Ms Access to SQL server 2000

Hi,
I want to import a database in Access 2003 to SQL server. I used import and
export wizard to do that, but in one step it wants me a username and password
to continue. It doesn't accept any users of windows active directory that has
been defined. Is there any other way to deliver my database to sql? if not
what should I do exactly to complete the import wizard?
Thank you very muchGuess you are prompted for SQL credentials, try this frist. If you don´t
want to use the Access Upsizer use the DTS from SQL Server to import the
data from Access.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"nkh" <nkh@.discussions.microsoft.com> schrieb im Newsbeitrag
news:212B585A-4892-4CFA-842B-A0F2446AC9A2@.microsoft.com...
> Hi,
> I want to import a database in Access 2003 to SQL server. I used import
> and
> export wizard to do that, but in one step it wants me a username and
> password
> to continue. It doesn't accept any users of windows active directory that
> has
> been defined. Is there any other way to deliver my database to sql? if not
> what should I do exactly to complete the import wizard?
> Thank you very much|||just as an aside, after you use the upsizing wizard, ensure that the fields
are the correct size... I had to reduce the length of many, many fields
afterwards, which gave me a big boost in performance...
--
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
(Please respond only to the newsgroup.)
I support the Professional Association for SQL Server ( PASS) and it's
community of SQL Professionals.
"nkh" <nkh@.discussions.microsoft.com> wrote in message
news:212B585A-4892-4CFA-842B-A0F2446AC9A2@.microsoft.com...
> Hi,
> I want to import a database in Access 2003 to SQL server. I used import
and
> export wizard to do that, but in one step it wants me a username and
password
> to continue. It doesn't accept any users of windows active directory that
has
> been defined. Is there any other way to deliver my database to sql? if not
> what should I do exactly to complete the import wizard?
> Thank you very much