Add a logical column called dup.
Replace all dup with .t.
Index on phone tag phone uniq
Replace all dup with .f.
When set to natural order all the of the dups are marked with true in the dup field.
I created a dbf table with the same format as the spreadsheet. When I use an "append from filename.xls type xl8" the error message is: microsoft excel file format is invalid.
If I open the spreadsheet and save as Excel 5/95, then FoxPro has no problem. Is FoxPro 6.0 incompatible...
I found the following code on your site and it works great. How do I add an attachment?
oApp = createObject("Outlook.Application")
oMail = oApp.CreateItem(0)
oMail.to = "whoever@wherever.com"
oMail.subject = "Email from VFP"
oMail.body = "Test email sent...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.