Re: Searching a DBF
Re: Searching a DBF
- Subject: Re: Searching a DBF
- From: James Yost <email@hidden>
- Date: Fri, 19 Sep 2014 11:18:16 -0700
On 9/19/14 8:48 AM, email@hidden wrote:
Once a month, we have to download a database of "excluded persons from here: and run our employee list against it to see if any are on the "excluded" list.
The first problem: The database is in ".DBF" format and normal Excel and Numbers will not open it. (The no-longer-supoprted AppleWorks will but...).
Ideally**, I would drop the zipped DBF file into a watched folder and it would unzip the file and compare the existing employee list to the database. reporting any found or a negative in the event none are found.
I have found that NeoOffice will open the DBF file and it can be searched. Any suggestions on how to automate this process?
I was looking at something like this last evening. It appears that DBF
can be converted to CSV, which Excel can read.
See:
http://www.techyv.com/questions/how-convert-dbf-csv-mac
J
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Automator-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden