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]


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



RXCarrier=Express Scripts










- 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

Навички: VB.NET

Деталі: 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

Про роботодавця:
( 65 відгуки(-ів) ) Bensalem, United States

ID Проекту: #12164049



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 Більше

$65 USD за 3 дні(-в)
(6 відгуків(-и))

12 фрілансерів(-и) у середньому готові виконати цю роботу за $212

$220 USD за 3 дні(-в)
(40 відгуків(и))

A proposal has not yet been provided

$500 USD за 30 дні(-в)
(6 відгуків(и))

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 Більше

$500 USD за 11 дні(-в)
(1 відгук)

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 Більше

$222 USD за 10 дні(-в)
(1 відгук)
$222 USD за 10 дні(-в)
(0 відгуків(и))

A proposal has not yet been provided

$166 USD за 3 дні(-в)
(0 відгуків(и))

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 за 3 дні(-в)
(0 відгуків(и))

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 Більше

$194 USD за 6 дні(-в)
(0 відгуків(и))

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 Більше

$100 USD за 5 дні(-в)
(0 відгуків(и))

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 Більше

$83 USD за 5 дні(-в)
(0 відгуків(и))

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 Більше

$166 USD за 3 дні(-в)
(0 відгуків(и))