Need to delete and import data into DBF file
Posted on 2008-10-24
Very early into this project (installing Visual Studio as I type this) and am looking to get some guidelines on how to go about completing
I have a CSV file with data which I need to import into a DBF file, I want to do this with a windows interface so the user can click on one of two buttons which will look for the CSV file in a specific location with a specific name and then depending on the button clicked delete records within a DBF file that have a specific value in a field and then import the data from the CSV into the DBF applying that value back into the field essentially replacing all data in the DBF for those records with that value, the other button works the same using a different value.
I am new to this and looking for an idea of which language is best to use to accomplish and the general guidelines to follow. I do have some experience with C# and VB not much however, I also have some SQL experience however have never worked with foxpro tables.
Thanks for your time