3 Replies Latest reply: May 15, 2014 9:57 AM by frenchman70 _ RSS

    Export to Microsoft Access

    Eric @ SEASH - EVV

      I am using Monarch V7 Pro. I have several routines I use autoscript for to speed up processing of data. I have not yet found a way to specifiy a table name in Microsoft Access for the data to export to....is this possible, or am I stuck with the default of "Untitled" ?

        • Export to Microsoft Access
          Bruce _

          Eric

           

          I made a project export in Monarch, assigned a table name using the export wizrd. Then I used the batch file to run this export.

           

          There is probably another method (did you look at the programmers guide?), but this method works with me for Access and Excell exports.

           

          Good luck

          • Export to Microsoft Access
            RalphB _

            Eric, are you using the "ExportTable(Summary)" command or the JetExportTable(Summary)" command. 

            The ExportTable or ExportSummary command only lets you specify teh File name only.  If you use the JetExport command you can specify the table name you want.  From the programmers guide: "JetExportTable(stringExportFile,string(TableName,IntegerAppendFlag)".  Same for the JetExportSummary.  I use them both in many scripts with success.

             

            Ralph

            • Export to Microsoft Access
              frenchman70 _

              Eric,

              I do this everyday via batch files.  I've placed .dbf tables in specific directories and then linked the tables in Access.  Linked is the key ... that way, the database always updates when the tables are updated.

              Just a thought.