Append using wild cards

[joenutts]

I have created an empty database, how I do append other files into this one when other files have different names.

Example;
Empty file Crmas.dbf
other files Crmas20020801.dbf
Crmas20020802.dbf
Crmas20020905.dbf

How do I combine the three files with the dates into my master file called crmas.dbf

 

[Mike Gagnon]

Take a look at the help files for APPEND FROM. Mike Gagnon

If you want to get the best response to a question, please check out FAQ184-2483 first.

 

[ramani]

Hi Joe,

nFiles = ADIR(laFiles,"myFile*.DBF&quot
USE (myFile)
FOR I=1 to nFiles
APPEND FROM (laFiles(i))
ENDFOR
...
...
ramani
(Subramanian.G),FoxAcc, ramani_g@yahoo.com
Merry Christmas & Happy New Year