В роботі

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

Навички: VB.NET

Показати більше: facebook contact import working, template system change php, excel import quickbooks, quickbook excel import iif, perl excel import, template header change color, quickbooks excel import file, quickbooks excel import deposit, working cart template, excel import mysql data, php scripts excel import, excel import sql 2005, joomla template color change, excel import wizard, quickbooks excel import

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

ID проекту: #12164049

Доручено:

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

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

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

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

A proposal has not yet been provided

$500 USD за 30 дні(-в)
(6 відгуків(-и))
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 Більше

$500 USD за 11 дні(-в)
(1 відгук)
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 Більше

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

A proposal has not yet been provided

$166 USD за 3 дні(-в)
(0 відгуків(-и))
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 за 3 дні(-в)
(0 відгуків(-и))
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 Більше

$194 USD за 6 дні(-в)
(0 відгуків(-и))
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 Більше

$100 USD за 5 дні(-в)
(0 відгуків(-и))
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 Більше

$83 USD за 5 дні(-в)
(0 відгуків(-и))
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 Більше

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