I'm looking for a way to convert .MDB files to .DBF. It doesn't even have to convert, export would work to.
This is in a windows setup, though I also have a linux box if that is where the solution may lie.
We have an online shop which dumps orders into a .mdb file. We download this file once daily, open it, delete where field is null, export it to a .dbf, then append it to an existing .dbf using foxpro.
We would like to set this up to be done automatically, so I have three .bat files. First one downloads the .mdb file, and uploads a blank one. The second one runs a .asp page which does "DELETE FROM onlorder WHERE ont_ouritm IS NULL", and the third one copies this to the directory where foxpro can pick it up.
However, the guy who setup the system told me that foxpro can't open .mdb files, which is why we opened the .mdb and exported it to .dbf previously.
Is there a way to set the convert/export up to run as a batch, or an easier way to do all of this?
Thank you much,
I've already done this for another client of mine. They had 3rd party Access-based system from which they wanted data automatically pulled into a system I wrote for them in Visual Foxpro. Used the standard Access driver that comes with Windows and voila, there's the data. You can compile your Foxpro program so that it's an EXE callable by the batch files...