Hi,
  Any one help me that i have a macros which generates reports in MSAccess taht i have to run in Sql Server.And one more thing i want to convert all the "queries" in MSAccess to Sql Server.

Hello,

SQL Server doesn't use macros (although the new SQL Server 2005 will support VB.NET code). You need to move them over to a VB program or vbscript.

SQL Server uses stored procedures, so copy them there. Although stored procedures have a different syntax for declaring the procedure and parameters.

Brian