application to import data into ODBC connected databases - will need SQL knowledge as well.

Closed Posted Jun 18, 2015 Paid on delivery
Closed 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.

.NET Database Development Software Architecture Software Development SQL

Project ID: #7890105

About the project

55 proposals Remote project Active Jul 25, 2015

55 freelancers are bidding on average $1161 for this job

sergioeliot3

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

$1250 AUD in 20 days
(116 Reviews)
10.0
leadconcept

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

$1546 AUD in 30 days
(56 Reviews)
8.6
thetechie13

A proposal has not yet been provided

$1184 AUD in 20 days
(84 Reviews)
8.1
NallakumarKC

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

$1184 AUD in 10 days
(101 Reviews)
7.7
maverick44000

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

$1300 AUD in 8 days
(54 Reviews)
7.5
sargardon

Hello sir/madam, However, I am new here in freelancer.com I have over 10 years of experience in .Net, SQL and VBA programming. Let me do your job first and accept my bid only after you get the results. Please contact More

$800 AUD in 20 days
(129 Reviews)
7.3
super2lao

A proposal has not yet been provided

$1500 AUD in 20 days
(93 Reviews)
7.5
lavizsolutions

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

$1500 AUD in 45 days
(19 Reviews)
6.5
haovo

Hello employer, I will use C# winform to allow user to load data from csv/xlsx file to the datagrid then user is able to select appropriate provider in ODBC connection string to import data from source file to desti More

$866 AUD in 10 days
(40 Reviews)
6.2
hectorenavarrou

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

$750 AUD in 14 days
(113 Reviews)
6.5
paskal77

Hello, I am interested in helping develop your project, I have worked with parameterized business rules based on data stored in database. Please talk by chat fore more information I am a web developer focused More

$750 AUD in 20 days
(71 Reviews)
5.9
ohuk

Hello, I found your offer very interesting for me. I'm skilled IT developer with more than 7 years experience with .NET development. I've developed wide range projects with using .NET for WEB an Desktop. I have used More

$1250 AUD in 20 days
(13 Reviews)
5.9
superior5

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,

$1500 AUD in 20 days
(37 Reviews)
7.2
vnb400sl

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

$805 AUD in 20 days
(111 Reviews)
6.0
godraw

A proposal has not yet been provided

$1250 AUD in 20 days
(1 Review)
5.8
sergpooh

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?

$1000 AUD in 30 days
(22 Reviews)
5.8
murtaza1981

Hi, Please feel free to discuss the project with me............................................................................. Thanks, Murtaza

$1250 AUD in 21 days
(11 Reviews)
4.6
jasuarezh

I work with .NET I create some windows programs, that read excel and csv files. I have experience in SQL

$1250 AUD in 3 days
(6 Reviews)
4.7
jatinkindra

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

$1250 AUD in 20 days
(4 Reviews)
4.3
Velutis

A proposal has not yet been provided

$1250 AUD in 10 days
(2 Reviews)
4.2