In Progress

Import Excel

Import Excel:

Must be done in VB 2010 & work in Win XP to Win 10

Open program with Main sub procedure in Module [url removed, login to view], get settings from ini file, & Load [url removed, login to view]

Main

1. Create a form ([url removed, login to view])to read 8 settings from an ini file

Show them in a text box and be able to edit save them back to the ini file

Use these 4 sections

[Main]

Fund=L98

RXCarrier=Express Scripts

[1262]

User=RichKoni

LastTimeIn=Now()

[409]

User=RichKoni

LastTimeIn=Now()

[Settings]

StartWhenWindowsStarts=Yes

Showintaskbar=YES

- User selects Excel file (From Common dialog box)

- User Selects Worksheet the data is in (From Common dialog box)

- User selects header row (If none, Map to Database)

*** user selects Data start row

- User selects number of rows to be added

- User selects which columns to add

- User supplies the "From" field text in the database. (Used to identify the source of data)

*** If the database does not exist Create it

***Default is [url removed, login to view] in [url removed, login to view] and user can change name, and save location

(Copy template database to working database )

Copy [url removed, login to view] to [url removed, login to view](Access 2003) or [url removed, login to view] to [url removed, login to view](Access 2007)

Access 2013 db should be available for future use

***User selects Access database Version and table to import to. (User can choose New)

- If database and or table does not exist yet, the program creates it.

- The program will check whether or not the columns (in the Excel) correspond to the columns in the Access database.

- The program will add all the data in the Excel sheet to the Access Database. (Add new fields to the table)

*** Trim all the fields imported to the database. (This removes leading and trailing spaces)

*** view the Table on the main form, and be able to edit the table.

Be able to Run in taskbar and start when windows starts

***Show source code & comments

Skills: VB.NET

See more: quickbooks excel import file format template, import excel file working excel template, quality center excel export working, template monster change html menu, results page working quiz template, facebook contact import working, template system change php, excel rate per day template, cre template help change background, excel import quickbooks, php free excel import script, quickbook excel import iif, perl excel import, template header change color, quickbooks excel import file, javascript selection value dropdown box change available values, quickbooks excel import deposit, excel loan amortization escrow template, php class excel import database, working cart template, excel import mysql data, php scripts excel import, web based excel import tool, visual basic excel import axcess, excel import sql 2005

About the Employer:
( 65 reviews ) Bensalem, United States

Project ID: #12164049

Awarded to:

Wesleyvm

Hello RichKoni, We already discussed in the chat before. I have to increase my bid a little bit because a few extra requirements have bee added: - Form to read and save data from and to ini file. (How will this in More

$65 USD in 3 days
(6 Reviews)
3.8

12 freelancers are bidding on average $212 for this job

$220 USD in 3 days
(40 Reviews)
5.6
jitendrabaraiya

A proposal has not yet been provided

$500 USD in 30 days
(6 Reviews)
2.9
sunsoftpro

First, I am sunsoftpro, I from VietNam. Nice to meet you! I have read your description and been interested in your project.  I'm ready to discuss and do hard working so that complete great job. Can you discuss requirem More

$500 USD in 11 days
(1 Review)
2.7
enmanuelsoria

I have extensive experience working with Vb.net, databases, and excel manipulation from VB.NET. so i am confident i can fulfill your request in a clean and efficient way. my offer asks for more time in order to let More

$222 USD in 10 days
(1 Review)
1.0
$222 USD in 10 days
(0 Reviews)
0.0
Freak05

A proposal has not yet been provided

$166 USD in 3 days
(0 Reviews)
0.0
iqmax99

Hi I would like to work with you on this project. I can do most of what you want in C#.NET vs 2015 except: - Start when windows start - Use MS-Access 2003 Regards, EK

$100 USD in 3 days
(0 Reviews)
0.0
mascotsoft4

Dear Client, Greeting of the day ahead !!! Thanks for providing us opportunity to place bid over the project and communicate with you. I am a serious bidder here and i have already worked on a similar project befor More

$194 USD in 6 days
(0 Reviews)
0.0
Irfan285

Hello, My name is Irfan, expert in web scrapping, data crawling and data mining, I have 5 years+ experience in data mining, website scraping, screen scraping I have completed 100+ projects on web scraping -- I WOULD More

$100 USD in 5 days
(0 Reviews)
0.0
KellogITSolution

Hello I am working with VB.NET for the past 7 years and have completed successfully a good no of projects through freelancer.com. I have gone through your project specification. I can do this and is ready to start n More

$83 USD in 5 days
(0 Reviews)
0.0
asadiqbalse

Hi. We are ready to start the project Development after checking out the project details We are a Genuine Website, Mobile Application Design & Development Company with 5 year’s experience. Our Professionals have worke More

$166 USD in 3 days
(0 Reviews)
0.0