Suljettu

Excel VBA - Connect & Update, Insert to SQL Server

This should be easy and quick for connection, insert and update in SQL. Using Excel VBA. Already have a tab with data to export to SQL.

Need to connect to sql to find matching Excel rows in SQL. If key matches, then update. If key not found then insert new record.

Taidot: Excel VBA, Microsoft SQL Server

Näytä lisää: vba code to import data from excel to sql server, excel vba export data to sql server, excel vba connect to sql server database, vba update database from excel, excel vba sql update statement, excel vba sql query example, how to get data from sql server to excel using vba, excel vba sql insert, sql server bulk insert excel, bulk insert load excel sql server, sql server 2005 example quick insert update delete, insert update master detail sql server, insert xml data type sql server using vba, running excel vba macro sql server, sample code update sql excel vba

Tietoa työnantajasta:
( 0 arvostelua ) United States

Projektin tunnus: #15113449

13 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

schoudhary1553

Greetings sir, i can help you to connect and instert data in to sql server and your 100% satisfaction is assured if you allow me to serve. I can do this task as per your requirement Relevant Skills and Experience I h Lisää

$50 USD 1 päivässä
(9 arvostelua)
4.6
AhmedHassan1122

Excel VBA expert with 2+ years of experience. Relevant Skills and Experience VBA for Macros. Proposed Milestones $25 USD - Full Price

$25 USD 1 päivässä
(12 arvostelua)
4.4
$25 USD 1 päivässä
(3 arvostelua)
3.0
$25 USD 1 päivässä
(4 arvostelua)
2.8
parulkumar44

I am very hardworking and I do my work with utmost dedication. I am new to freelancer.com and looking forward to an employer to hire me and recognize my work and potential. This task can be done with SSIS. Experience Lisää

$40 USD 4 päivässä
(3 arvostelua)
3.0
adrianbrough

I will write merge code in SQL. If you can alter database I will put merge code in database stored procedure and call from VBA otherwise I'll code SQL directly in VBA. Relevant Skills and Experience SQL Developer / DB Lisää

$25 USD 1 päivässä
(1 arvostelu)
3.2
abhinovpankaj

I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Relevant Skills and Experience VBA and Excel,Word,Office Applications -- Expert on C# usin Lisää

$35 USD 2 päivässä
(2 arvostelua)
2.6
$25 USD 10 päivässä
(0 arvostelua)
0.0
ryguysl

Hi, Happy to bid on your project. I love working on Excel VBA and I've actually written VB.net apps that have done this as well. You'll need to provide connection string information (like DB name and user account detai Lisää

$54 USD 2 päivässä
(0 arvostelua)
0.0
gopalnbiradar

A proposal has not yet been provided

$35 USD 5 päivässä
(0 arvostelua)
0.0
nsabale

Hi, We are specialised in below skills -Excel macro development -Automation script development -creation of automation software frameworks -Creation of process automation -Provide manual and automation frameworks Lisää

$25 USD 1 päivässä
(0 arvostelua)
0.0
cutepraba

I readily have multiple these kind of Excel files for my daily day tasks. Relevant Skills and Experience 10+ vb6/vba/mssql experience Proposed Milestones $20 USD - on finish Remote or offline work?

$20 USD 1 päivässä
(0 arvostelua)
0.0
DeamEyes

I have experience saving data from excel to sql using vba code.

$35 USD 3 päivässä
(0 arvostelua)
0.0