I gang

Excel Spreadsheet - Insert/Update SQL Server Not dBase

We currently have an Excel Spreadsheet which reads cells, then checks a foxpro dBase database if the data exists and if it doesn't, it inserts it into the FoxPro dBase Database.

The FoxPro dBase database has been REPLACED with a SQL Server 2005 instance and so the VBA must be adjusted to read the SQL Server Database.

Only 3 tables are inserted/updated in this process.

The changed VBA must therefor:

1) Setup the Connection to the SQL Server

2) Check is the record exists (as it does in the old code)

3) Depending if it exists, either insert or update (as it does in the old code)

This project is very very small. Changes are only expected in one 1 module.

Færdigheder: .NET, Visual Basic

Se mere: sql spreadsheet, dbase update sql, sql update dbase, dbase spreadsheet, excel sql insert, spreadsheet insert, we excel, update sql server spreadsheet, sql exists insert update, vba code excel, vba excel, update old, sql code, spreadsheet 2, insert, foxpro, project database vba excel, excel database visual basic, foxpro database, vba update excel, excel update net, setup database excel, spreadsheet vba code, excel 2011 vba, net vba

Om arbejdsgiveren:
( 4 bedømmelser ) Northriding, South Africa

Projekt-ID: #1002493

Tildelt til:

northwolves

Check PMB please.

$35 USD på 1 dag
(33 bedømmelser)
4.7

16 freelancere byder i gennemsnit $53 for dette job

srinichal

Send in the macro to make the adjustment

$60 USD in 3 dage
(64 bedømmelser)
6.6
tamrakar81

Hi, Please check PM . Thanks , T

$50 USD på 1 dag
(34 bedømmelser)
5.2
mainpoint

I Can do this project.

$30 USD på 1 dag
(8 bedømmelser)
4.6
yehia111111

hi ,i can do it for you

$30 USD på 1 dag
(3 bedømmelser)
2.9
sajanyamaha

This is a small work,you tell me the bid price,i will do it for you.Contact details attached here,,

$50 USD på 1 dag
(4 bedømmelser)
2.9
softvn

I can done. Please check PM.

$45 USD på 1 dag
(2 bedømmelser)
2.5
narinderbti

Lets start. Please provide the script. Warm Regards Team ViewOmega.

$55 USD på 1 dag
(2 bedømmelser)
2.3
Boy1984

Hi. I can done it. Thanks.

$30 USD in 2 dage
(2 bedømmelser)
1.7
pavanasamr

Hello, Please check your PM.

$30 USD in 2 dage
(1 bedømmelse)
1.0
aqm163

Please view private message.

$50 USD in 0 dage
(1 bedømmelse)
0.0
mitss

please kindly check your PMB thanks.....

$200 USD in 8 dage
(0 bedømmelser)
0.0
varunrawat2

Greetings, I’m the Co-Founder & CEO with WisKnowTech Software’s, one of the emerging India's highly skilled technology experts. We specialize in giving an App idea a concrete shape with a Guarantee of Excellence, Qu Mere

$50 USD på 1 dag
(0 bedømmelser)
0.0
mrbig81

Plz check your pmb.

$50 USD in 5 dage
(0 bedømmelser)
0.0
dreamsoft4u

Hi, we at dreamsoft4u have vary good experience in introp services like excel,word etc.............

$50 USD på 1 dag
(0 bedømmelser)
0.0
jainkushagra6

Dear Sir Please check PMB

$30 USD på 1 dag
(0 bedømmelser)
0.0