Search results for query: *

Issue resolved. It is working. Created another table to store the value for incremnting. Thank you all for your help!

point taken. Sorry about that. I will dig in and take your suggestion. Thank you.

Thank you, Mike. The results, for each time the program runs, starts at 35,000. With the above code, I need to "store" the very highest number in the merge in a variable and then increment so that the number keeps going up. Can you please take a look? It is working as far as the numbers entered...

All set, got the dang thing going! Thank you very much for your help on this. I will copy this post for further exploration as I learn. You are an inspiration and a great help. Thanks again....

Thanks JRB-Bldr; stil getting "Variablbl importid not found" even though that field is in Merge... *SET EXCLUSIVE OFF * 1. Setup excel headers (Source doc) * 2. Save excel as dbf (Table #1) * 4. Export Exceed to excel * 5. Convert Exceed excel to dbf (Table # 2) * 6. Scan for dups * 7...

Hello all; this is the last thing, I promise.... Ran into a snag with the content managment program Exceed. It stores ID's in the Importid field from old records so at anytime there are id's like 1000-2000, with 35000 being the top end. Wehn I export to the .CSV, I need the numbers to start at...

Thank you jrbbldr and baltman...All set. I appreciate your time and expertise..

Sorry; just to clarify: The codes BMPR, HTTO should corespond to certain companies: BMPR = Buffalo Medical Primary Reception HTTO = Hospital Transfer Trace Occupational etc... Please let me know if ther is a simple way to do this.. Thank you in advance for your time/help..

Hello; I hope I can get a little help/direction. I have one more step in this process to get my program working correctly. There is a field called AFFIL that is supposed to have affiliate codes automatically assigned as the files are uploaded in the temp directory. Examples of the codes are...

Great! I modified and it is now working. Thank you for your help.

That saved the file as you mentioned as a csv. Thank you very much! One last question, please. Where can I define the correct column headers for Exceed: ex: AIDNO(exceed creates primary number) LNAME FNAME SLNAME SPOUSE ORGNAME This is what was in the new Exceed file: a...

Yes, the Exceed program only accepts .csv so I am trying to automate this with VFP. It needs to export the .csv and use the column headers in my previous post. Can the exported file include the column headings, or would I have to do this manually?

Thank you for the reply and information, JRB-Bldr and Mike. I have this working, it is deleting dups when I chose yes and passes when I chose no. The last thing I could use a bit of advise with if at all possible is how to EXPORT to Excel and convert the file into both a .csv (the file is to be...

Hello again; Thanks for the earlier replies. I am close to having this working but still a bit off. Please let me know if you have any ideas. When I open the program and chose a "source" Excel file to match against MERGE, it goes through each record with the messagebox. The record that pops up...

Thank you both. I will rework with your suggestions. Thank you

Thank you Mike; one file is exported from a contact managment program called Exceed, the other file will be an Excel file sent by user. I must export the Exceed file, change to a .dbf and check it for dups against the user supplied Excel, that will also be changed to a .dbf.

Hello; hope to get a little help. Have two source files I need to check for duplicates within Visual Foxpro 9. Below are the steps I need to impliment and below that is the actual code. I am close but need help with the code to make sure this will accomplish what I need. I appreciate any help...