Looking for good Migration tool which can convert Access db to SQL

I'm looking for migration tool which can convert Access database to SQL
Server. Any one which works 100%. Any suggestions would be greatly
appreciated.
Regards,
RaoRao
Linked Servers?
---
SELECT *
FROM OPENDATASOURCE(
'Microsoft.Jet.OLEDB.4.0',
'Data Source="d:\northwind.mdb";
User ID=Admin;Password='
)...Customers
"Rao" <Rao@.discussions.microsoft.com> wrote in message
news:7215F579-1C4C-4F6D-AF5B-6D0D12117772@.microsoft.com...
> I'm looking for migration tool which can convert Access database to SQL
> Server. Any one which works 100%. Any suggestions would be greatly
> appreciated.
> Regards,
> Rao
>|||You can import the database using DTS. Do mean that you want to also carry
over all the queries, etc. and have the SQL properly translated as well?
"Rao" <Rao@.discussions.microsoft.com> wrote in message
news:7215F579-1C4C-4F6D-AF5B-6D0D12117772@.microsoft.com...
> I'm looking for migration tool which can convert Access database to SQL
> Server. Any one which works 100%. Any suggestions would be greatly
> appreciated.
> Regards,
> Rao
>