Solve : Combining DBF files?

1.	Solve : Combining DBF files?
Answer» I have 1508 DBF files that need to be combined into ONE FILE. Each file contains different data but all have the same column names. Is it possible to combine them using a dos command? Thanks! There are lots of different types of DBF file, but you have not TOLD us which database program these files came from. If they came from Foxpro, you could try a Foxpro program such as the following This is not a batch file Code: [Select]Select one database as your main file, which all records of the OTHERS will be appended into. Place all of the other ones into their own directory. This directory should hold only those other databases, no other files. USE mainfile SET DEFAULT TO <pathAndDirectory> =ADIR(laDBFs,'*.dbf') FOR lnDBFcnt = 1 TO ALEN(laDBFs,1) lcDBFname = laDBFs[lnDBFcnt,1] APPEND FROM &lcDBFname ENDFOR RETURN

Discussion