can u say how to write scripts in Ms Access?

[raghunadhs]

Hi All,
i have two databases. one is SQL server 2000 and another one is MS-Access.
initially I have same data in both the data bases. but now i made some changes in Sql Data base by writing some scripts (script contains sime update,select,insert statements and if clause.
I want to do the same changes on Access data base also. is it possible to write the scripts in Access-2003?
I tried with a simple example. i wrote an insert statement in a .txt file. now i am reading that query using "Module" in the Access. following is the example written in "Module" of Access Databse.

  
     Option Compare Database

  Sub macro1()
       Dim sFileText As String
       Dim strQuery As String
       iFileNo = FreeFile
       Open "c:\sample1.txt" For Input As #iFileNo
       Do While Not EOF(iFileNo)
           Input #iFileNo, sFileText
           strQuery = Replace(sFileText, "99", ",")  '--it replaces 99 with ,
          DBEngine(0)(0).Execute strQuery
       Loop
 End sub

since, while reading the data from the file, it is not accepting "," (comma), i used "99" instead of "comma" and replaced it again in the string.
for this simple statement, it is working fine. but it is not working for "if" statement ...etc.

so can u suggest me any method to write the scrits in Access 2003? my requirement is i should be able to update the Access database with minimum efforts by using the scripts what i alreay used for SQL.

thanks in advance...