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
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
Do you know how to write event procedures in VB?
You will have to write one for the command button click event. In that procedure you will create the appropriate file reading and SQL statements to accomplish your task.
Unfortunately I do not have Visual Studio installed. My knowledge of these things is derived from MS Access (Visual Basic for applications).
Perhaps someone else will have the knowledge to flesh this out for you.
Are you still open to other language choices?
"ok so I am using VB.Net for the moment"
"I dont know the code to use in VB.net "
It sounds like this is a question for another forum - specifically a VB.net forum where you can find an audience better suited to answer your VB.net questions.
Once you understand the necessary basic syntax in the language of choice (regardless of the back-end table you are using), then for specific VFP questions, we are here to help.
Good Luck
Business Accounts
Answer for Membership
by: CarlWarnerPosted on 2008-10-24 at 07:28:53ID: 22796583
Here's a good place to start:
How to: Access Visual FoxPro Data in Visual Studio
http://msdn.microsoft.com/
Microsoft OLE DB Provider for Visual FoxPro
http://www.microsoft.com/d