Excel Spreadsheet - Insert/Update SQL Server Not dBase
$30-250 USD
Kiszállításkor fizetve
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.
Projektazonosító: #1002493
A projektről
14 szabadúszó tett átlagosan 54$ összegű árajánlatot erre a munkára
Hi, we at dreamsoft4u have vary good experience in introp services like excel,word etc.............
