|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...REPLACED with a SQL Server 2005 instance and so the VBA must be adjusted to read the SQL Server Database.
1) Setup the Connection to the SQL Server
2) Check is the record exists (as it does in
||Visual Basic, .NET
||Mar 29, 2011
||Mar 29, 2011Ended
|Update Excel spreadsheet using Zillow API
||Using Address information on a spreadsheet, populate the spreadsheet with Zestimate and high - low values... Optional, gather this data and insert into SQL Server database.
||PHP, SQL, Software Architecture
||Oct 6, 2010
||Oct 6, 2010Ended
|Excel Spreadsheet to SQL Database
||Populate a SQL Database from an Excel Spreadsheet for a search function on a Web Site.
Customer...repopulate the SQL Database as the Spreadsheet gets larger.
Small 100KB Spreadsheet, SQL 7, Windows Web...Web Server
We want to capture customer information such as email address and contact. Customer will enter
||PHP, Windows Desktop, Engineering, SQL, Software Architecture, Software Testing, Website Testing, Microsoft, MySQL, Website Management, Web Hosting
||Feb 26, 2004
||Feb 26, 2004Ended
|Excel to SQL Server Import
||...from an Excel spreadsheet with a strictly defined layout that has already been designed into out SQL Server...Server database.
The spreadsheet and a relavent datamodel will be provided.
The program should...in VB.NET as a WinForms application.
The spreadsheet contains eight sheets. Each is loaded into a
||PHP, Visual Basic, .NET, Engineering, Excel, SQL, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL
||Feb 17, 2004
||Feb 17, 2004Ended
|Excel Spreadsheet Update Service
||...Service that updates an Excel object called "QueryTable" inside many? Excel Spreadsheets.
Once a...service must update the "Url" value of "QueryTable" object inside the Excel Spreadsheet and save the...in the spreadsheet to disk.
The Windows Service will run on its own server and will update approxim...
||PHP, Windows Desktop, Project Management, Engineering, C# Programming, Software Architecture, Software Testing, Microsoft, MySQL
||Oct 17, 2008
||Oct 17, 2008Ended
|Update an MS Excel Spreadsheet
||I have an excel spreadsheet that requires some updates (see attachment). The spreadsheet is used to calculate...is no longer needed. To do this you will need to update any formula that uses this column. 3. The specifics...select an editor (like cell G40) to row 34, and update the cells on rows 36 to 38 to summarize the Overall
||Excel, SQL, Powerpoint, Microsoft Access, Word, Microsoft Exchange, MySQL, Database Administration, Visual Basic for Apps
||Jun 4, 2009
||Jun 4, 2009Ended
|Excel to sql server
||...modeled off an excel program. The code is in place and is similar to the excel spreadsheet that I am attaching... I have ported this to the web using asp and sql server. What I am looking to do is find an easy way...way(not sure on this) and have it converted to sql server. The input page and database are already setup
||PHP, ASP, Engineering, Excel, SQL, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Website Testing, Microsoft Exchange, MySQL, Website Management, Web Hosting
||Jul 5, 2003
||Jul 5, 2003Ended
|script to add excel spreadsheet into SQL server
||...a write a simple script to add an excel spreadsheet into SQL server 2000.
1) Complete...the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in...Seller Legal Agreement).
sql server 2000
||PHP, Engineering, SQL, Software Architecture, Software Testing, MySQL
||Sep 11, 2006
||Sep 11, 2006Ended
|Excel spreadsheet to Online SQL database
||I have an Excel spreadsheet that I would like to use to update an online SQL database. I would like...in the spreadsheet which then updates my online SQL database with this information. The SQL database...propose to do it.
Must be compatible with MS Excel 2007. If you need any further information please
||PHP, Excel, SQL, MySQL
||Jun 12, 2012
||Jun 12, 2012Ended
||I have a spreadsheet that I want reviewed and updated. I need each cell reviewed to ensure its proper...the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in...Legal Agreement).
This is an excel spreadsheet in a Windows environment.
||PHP, Windows Desktop, Linux, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Mac OS, Software Testing, Word, Microsoft Exchange, Chrome OS, MySQL, UNIX
||Nov 16, 2004
||Nov 16, 2004Ended
|asp.net c# /sql server update
I've got an existing c# asp.net /sql server website with a homepage, about us page, contact...upload parts of a suppliers as an excel sheet. the problem is that the excel sheet has dates that might appear...the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in
||PHP, ASP, .NET, Windows Desktop, Engineering, SQL, C# Programming, Software Architecture, Software Testing, Website Testing, Microsoft, MySQL, Website Management, Web Hosting
||Apr 12, 2007
||Apr 12, 2007Ended
|Data from Excel to SQL server
||...therefore use Excel spreadsheet to create our quotations. Our ERP system use SQL server as the database...to connect this spreadsheet to the SQL server so that we can still use the spreadsheet to configure our...item list which then can be transferred into the SQL so that we can view and process quotes from the ERP
||Data Processing, Excel, SQL, Database Administration
||Apr 18, 2013
||Apr 18, 2013Ended
|Convert Excel Spreadsheet to PHP
||...programmer to convert an Excel spreadsheet to a PHP 4 script. The Excel spreadsheet will be provided to the...stand-alone and not rely on Open Office or other spreadsheet code or components. Your role will be to build...of the existing spreadsheet. It does NOT need to be AJAX. A refresh button to update the figures is OK
||PHP, Engineering, Software Architecture, Software Testing, MySQL
||Dec 12, 2006
||Dec 12, 2006Ended
||Jun 30, 2009
||Jun 30, 2009Ended
|Need to generate Excel spreadsheet from traditional asp page or sql server for google base
||...page displaying a large dataset pulled from my sql server database, but it is about 32k records, and the...transfered to XML or excel spreadsheet in order to upload to google base. The Sql statement is already...already written, but I would like the ability to update the statement to produce new results or additional
||Script Install, Shell Script, Amazon Web Services
||Apr 10, 2012
||Apr 10, 2012Ended
|Sync Excel With SQL Server Table using Microsoft Access
||...connects to a SQL Server 2005 Database. I need to synchronize a table in the SQL Server 2005 database...database with an Excel 2003 or 2007 spreadsheet. I have written the logic to determine which records to insert/update/delete...insert/update/delete from the database based on the data in the Excel spreadsheet. It functions properl...
||SQL, Microsoft Access, MySQL
||May 23, 2010
||May 23, 2010Ended
|424046 SQL Spreadsheet
I have 2 excel sheets I need transformed into an online SQL spreadsheet for sharing with my...and freeze panes are required ! I will need to update this sheet daily in an easy and intuitive way,...mysql...
The two sheets are ready to be used, Excel 2007 format. One is 66ko the other 800ko
||Excel, SQL, MySQL, Anything Goes, Database Administration
||Jun 29, 2010
||Jun 29, 2010Ended
|Update Macros and Code in Excel Spreadsheet
The spreadsheet "Orders.xls" is used for tracking orders at a manufacturing plant and the...the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in
||PHP, Visual Basic, Engineering, Excel, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL
||Jul 10, 2004
||Jul 10, 2004Ended
||Data Processing, Data Entry, Excel, SQL, Web Scraping
||Jan 7, 2011
||Jan 7, 2011Ended
|Simple Excel Spreadsheet Update Function
||I have a huge Excel spreadsheet with customer information (email addressess, names, addresses, etc.)...) in it. Then I get a smaller spreadsheet with only email addresses which are customers to be deleted...deleted from the main spreadsheet. Very simple search and delete if found. Can be ".xls" format or ".csv" format
||PHP, Web Security, Project Management, Engineering, Excel, Computer Security, Powerpoint, Software Architecture, Microsoft Access, Software Testing, Word, Microsoft Exchange, MySQL, Google Chrome, Apple Safari
||Oct 25, 2006
||Oct 25, 2006Ended