hai,

I have to convert the remote MSaccess database to sql
server database.

How can I achive this. Please give me details.

Thanks in advance,

With regards,
Prakash.

There is an Access upsizing wizard.
If you want to simply pump data between Access and SQL Server then create a
DTS package to do this

Add an Access connection and a SQL Server connection.

This article will help you

Importing A Text File Using The DTS Wizard
(http://www.sqldts.com/default.aspx?276)

--


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org