application to import data into ODBC connected databases - will need SQL knowledge as well.
$750-1500 AUD
Paid on delivery
Create software which will be used to import csv\excel files in to various ODBC connected databases.
Connections will already be set up in the windows DSN servers ([login to view URL])
The program will have a section where you can define a routine like so-
Set the routine name, select which fields in the csv\excel file goes to which field name in the database, select the data type (text, double, number), select if it's a required matching field, select if the routine will be used to Update,Delete or Add the records.
The routine is saved and can be recalled later
note: The 'required matching field' is where the user indicates that the value in the file must match the value in the database - otherwise it will skip that record.
The user will then add files to the list, select the DSN connection and select the routine to be used on that file.
Once the user hits go, the program will get the data from the file, create the SQL script according to the routine, and then run the script to update the data from the file.
I have limited knowledge of .NET, good knowledge of VBA and work with databases. That being said, I should be a lot easier to work with due to what I do understand :)
I have created this in Access and knows it works however I would like a standalone application so I can add features and not depend on MS Access to be available.
Thank you.
Project ID: #7890105
About the project
55 freelancers are bidding on average $1161 for this job
Hi! I'm ultra-interested in your project. Stand alone win forms applications are my favorites when coding. Also I'm so very used to importing/exporting data from to csv and txt files that on my mind I had flashbacks o More
Greetings, I have read Project Description & interested to work with you, as our .NET team is very strong. I understand that you do not have experience in .NET, so that's not a problem, all we need is your feedback More
Hi, I am Nallakumar. I have more than 8 years of experience in .NET. I would suggest to keep the routine details in the form of xml and save it in a local path. So, when the user opens the applicaiton for the nex More
Hi Sir. I have developed several applications which use Data source name from DSN and insert data into corresponding database. I can develop a .Net application which shall do the job for you. It shall have a customizea More
Hi, I can provide you solution in visual basic 6.0, we can manage all the things, need to ask 1. is all dsn connected database will have same structure of tables. can I have a sample csv file. 2. all csv files wi More
Hi, first let me tell you that the project can be done for a lot less than you are proposing here. Actually I set up a milestone for what I think it costs, and the other milestone wil not be needed. About the project, More
George Bailey here from Los Angeles, USA. I am expert in ODBC, SQL and have done similar task already. I would like to help you out in the project. Hope to hear back soon, Regards,
Respected Sir i can develop an application (frontend) in .net framework (c# or vb.net) to connect to the databases using ODBC and Import data and other after selecting data. Warm Regards vnb400
Hello. It's interesting task for me. I with pleasure help you. Only one question: Excel is installed on PC or need program which not depend on MS Excel too?
Hi, Please feel free to discuss the project with me............................................................................. Thanks, Murtaza
I work with .NET I create some windows programs, that read excel and csv files. I have experience in SQL
Hello I have hands on experince working with similar applications, experience with .net\mvc\c#\windows application. Lets discuss more over actual requirements and we can proceed then. Can assure of quality & long More