List of automated tool to convert Access database, query, form and interface to SQL Server

[gpaille]

I got a big Access database I'd like to convert to MS SQL Server 2000
and I'm looking for an efficient automated tool to convert data (over
1 400 tables), query, forms and interface.

Does somebody can provide me with a list or, at least,a suggestion of
tools that has already been used or well known for their
efficiency.(except upsizing wizard and DTS, I tried with no success,
since I'm not a programmer)

Thanks,

Guy

[MacDermott]

Here are a couple of thoughts:

AFAIK, SQL Server does not provide any way to build forms.
Tables can be upsized using the wizard and DTS.
Queries may need to be rewritten using T-SQL, instead of the Jet version.
I don't know what you mean by "interface".

If you're not a programmer, I doubt that you'll be comfortable working in
SQL Server.

HTH
- Turtle

<gp*****@emarkethink.net> wrote in message
news:43*************************@posting.google.co m...

I got a big Access database I'd like to convert to MS SQL Server 2000
and I'm looking for an efficient automated tool to convert data (over
1 400 tables), query, forms and interface.

Does somebody can provide me with a list or, at least,a suggestion of
tools that has already been used or well known for their
efficiency.(except upsizing wizard and DTS, I tried with no success,
since I'm not a programmer)

Thanks,

Guy