Hello, I have several (hundreds) of dbf database files which have a field which needs to be removed from each record in the file. The field is the FIRST field in the record.
There are something like 20 fields, and usually less than 100 records in each database.
Is there any way for a macro to import a dbf file, remove the first field, then save the file to a new file, minus the errant field? I could open each dbf file in excel, delete column A, save the worksheet as a csv and go on to the next file, however like I said I have hundreds of files that I need to do this to.
I can provide a sample of the dbf files if necessary.
Thanks,
Michael Quam