Thanks for the quick response. I had taken a look at that, but it seems to say that I can only overwrite files or create new files. I need to append the information into an existing table in an existing access database. In addition, the project export that I have created uses a filter and I didn't see an option to specify a filter.
Is this sort of automation available through the command line? If not, is it possible through VBA?
Yes, I actually just downloaded the programmer's guide earlier this morning.
I don't have v7 Pro, but with 8 Pro you cannot append to a table with the command line. I'll assume that this is also true for v7 Pro. So, instead you must use the JetExportTable command:
[font="courier"]JetExportTable(FileName, TableName, 2) /font[/quote]The 2 parameter indicates that you want to append to the table. Use 0 to overwrite the table, or 1 to create a new table.
As to the filter, you want to set the CurrentFilter property. One caution here: always check to see that the filter you specified was applied. If you specified a filter name that doesn't exist in the model, Monarch just charges on with the current filter without raising an error condition.
I like to do something like this:
If objMonarch.CurrentFilter <> strMyFilter Then
'exception code goes here
Msgbox "Requested Filter does not exist!"
End If[/font][/quote]See the Programmer's Guide for full descriptions of the above.
There are quite a few programming examples posted on the forum now, but if you need more help, just ask.
[size="1"][ March 17, 2006, 03:17 PM: Message edited by: Data Kruncher ][/size]