Updating Access Table field from a batch file.

  • Hi All,

    I need to update a field value of an Access Table using a .bat file.

    I would like to write CommandLine commands to update the field value of a table. I have created a macro in Access and used /x option to run the macro from the batch file. Its not working as mentioned in the help.

    Can we use osql or any other utility to run Access Queries from Command Line Prompt? Please suggest me any better option or an alternative for doing the same.

    Thanks in Advance,

    Subhash

  • Try renaming your macro to autoexec - this should then run automatically. If you want to run some code then use the runcode action in a macro or create a procedure called Main and that should run automatically.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply