Deji Akala 28.Oct.11 12:50 PM a Web browser Approach 9.8 All Platforms
I've got a big problem. I've inherited an old Lotus Approach database with some "programs" which run some queries and export the data to *.dbf files. These have been saved as *.APR files also. When I try to open any of these *.APR files in Lotus Approach, I get prompted to name the file I want to export data to. It seems to me the previous developer saved the macros as *.APR files and then runs them in a batch file. For the life of me, I've been unable to work out what's going on, how to open the *.APR files to see what the macros are doing etc.
What I want to do is run macros in a batch file, in order to export data into *.dbf files programmatically. I can do the first bulk export/import manually but updates will be too tedious to do on a daily basis.
On the whole, I want to do a bulk export of the Approach database into a SQL server database. I can do a manual export into Visual FoxPro files from which SQL server can extract the data. However, I want updates to be exported to Visual FoxPro format for me to continue the data processing from there.
So the million pound question is, how do I get the data out of Approach programmatically?