Em Andamento

VB6 form to import data from Excel to SQL

Require a form (attached in project file as .frm file) to import data from excel file (attached) into a SQL table. The import process should not use bulk import or bulk copy. I require that the .frm (attached) is completed with the neccessary code to import the data from the EXCEL document into SQL server (table script attached). I have attached the following files from the VB project (applicationevent, the form (.frm) and the main event. I would like the form to produce a popup box if it attempts to load the incorrect file (i.e. the columns in the excel file attached should be the case all the time). If any columns exist that are outside of these columns when attempting to import the file display a message box (this would be before the SQL query runs). The SQL query within the form should use a simple INSERT to insert the data into the NPCMA_Positions table.

Habilidades: SQL, Visual Basic

Ver mais: visual basic form excel, excel with sql server, excel to sql, load excel, script process excel files, simple script excel, excel sql query, import data form excel, import excel sql process, visual basic case project, vb6 sql server project, import excel vb6, copy table vb6 code, vb6 code bulk insert, vb6 bulk insert, vb6 sql import, import bulk data, bulk insert sql server vb6, sql server import data excel, excel sql insert, import data excel sql, vb6 sql code, sql sql import vb6, visual basic copy table, copy table vb6

Acerca do Empregador:
( 27 comentários ) Sydney, Australia

ID do Projeto: #6806390

Premiar a:

gperete

Software developer since 2000, specializing in Visual Basic, SQL Server, Crystal Reports, and VBA for MS Office.

$30 AUD em 1 dia
(8 Avaliações)
3.7

12 freelancers are bidding on average $32 for this job

sumon355

Hello, I am interested to do this work as i am experienced a lot in vb6 as well as sql related works. Looking forward to have a positive response from you. Thanks

$28 AUD em 1 dia
(47 Comentários)
5.2
Maheshml

hij i can do this. i am expert in vb6. Hoping for positive response .

$30 AUD in 5 dias
(5 Comentários)
4.4
pointnetfrance

Hi. I am a Senior VB6 and VB.NET Developer living in Paris, I have read your specifications and i want to help you to realize your application. I invite you to see in my folio the kind of application i have realize Mais

$40 AUD em 1 dia
(1 Comentário)
2.9
kmpal

Hi, I am an experienced developer with vast experience in .NET, MVC and SQL available for this project. I am full time freelancer available 10 hours daily. Thanks and best regards Khalid Skype - khalidpal Mais

$30 AUD em 1 dia
(1 Comentário)
2.4
lillysoft

A proposal has not yet been provided

$55 AUD em 1 dia
(2 Comentários)
2.2
m7medcs

A proposal has not yet been provided

$15 AUD em 1 dia
(0 Comentários)
0.0
alltechworks

I have read your tender and understand your requirements. I will bring very strong VB6 skills along with over 20 years programming experience to bear on this role. Please contact me if you are interested in my of Mais

$55 AUD em 1 dia
(0 Comentários)
0.0
softtechsurat

hello sir/madam we have 15 years of experienced in vb6 and have developed more than 100 softwares. we are the best to complete this project. looking forward to be hired by you soon. Regards, Softtechsura Mais

$35 AUD in 2 dias
(0 Comentários)
0.0
pnrfreelancer

Hi, We've 10 years of experience in field of excel,VBA, VB,.Net programming,MS Access, MySQL, SQL Server & Sql Express 2005. We did data importing work in many projects so as to accomplish our project without interrup Mais

$27 AUD em 1 dia
(0 Comentários)
0.0
sangxuan

Đề xuất vẫn chưa được gửi

$25 AUD in 3 dias
(0 Comentários)
0.0
nmskk

Professionally I am a Sr. Software Developer having more than 4 years of experience in software programming. I have developed many kind of applications in VB6. So, I think it won't be difficult for me.

$25 AUD em 1 dia
(0 Comentários)
0.0
sathiyams

A proposal has not yet been provided

$15 AUD em 1 dia
(0 Comentários)
0.0