...SCAN BUSINESS CARD VIA MOBILE CAMERA --> OCR READ --> POST DATA INTO OUR ERP SQL SERVER DATABASE OR MOBILE CONTACTS B. BULK EMAIL INTERFACE FROM MOBILE OR WEBSITE OR SQL SERVER DATABASE BASED ON FORM OR PARAMETER INPUTS. API INTERFACE WILL BE PROVIDED TO BULK EMAIL SERVER C. SMS USING MOBILE PLAN OR BULK SMS INTEGRATION TO OUR ERP FROM OUR CRM OR
I need a person who can work in SQL Server Data Tools 5 Question need to answered using [SSAS package solution (BIM and EXCEL files)] OLAP data file will be provided Q1: How many vendors have low quantity on hand (<10), medium quantity on hand (<50), and high quantity on hand (>50)? Q2: In DimDate, create ‘Fiscal’ hierarchy that include
...out Part Number and Qty. required from the above emails - Check Part Number against Own Stock o SQL Database on Server Gather Own Stock details to build a Quote - Check Part Number against ‘Special Parts’ Spreadsheet o Excel File saved on Server with set fields Gather Stock details to build a Quote - Check Part Number on Various websites
Hi Le T., You built me an excellent solution to use a central SQL database to update information in excel documents we use for cost calculations. We would now like to consider taking this to the next level. The goals would be to have - an online record of every version of the costing being created. - reporting on each costing. - ability to have
I would like to load a sql file in SQL Server. I myself know mssql and tried it. But, the problem coming is that sql server is reading only few rows not all rows. It is only few minutes of work for an expert. Can anyone do it. Further details will be shared later.
Currently have a relatively simple web application that is written in Active Server Pages (with Frontpage) which uses Microsoft Access as the database engine. The project is to convert this application from Access to SQL. The application is for a non profit, charitable organization that collects and distributes Christmas Gifts to needy foster children
We require a GST Enabled Double Entry Accounting Software with source code in whi...with source code in which Clients, Product, Sale, Purchase, Transaction, Trail Balance, Balance Sheet, Day Book developed in C# SQL Server, Crystal Reports Dot. Net Framework 4.0. Having features to import sales from excel sheet can import data from tally software
...web portal in [url removed, login to view] with SQL Server with following functional scope: Administration panel User creation and management Data import workbench Change password View own profile SAP Vendor master SAP Material master SAP Purchase orders Supplier panel View my purchase order Download Purchase Order (Excel) Print purchase order (pre-def...
Hi, I need some VB / Macro to insert only new data into a Microsoft SQL server. Attached is a demo workbook which has a demo of the 2 sheets in excel which needs to be inserted into the database. - Only new data should be inserted into the database - Keys are User_id, Date & Time - I need to be able to run the macro without interface from a user
Seeking a developer to create a web portal with a...authentication. Create the ability to upload and download a standardized excel template that will update a SQL database based rules. This portal will also provide reporting capabilities in the form of a dashboard. Skills: Excel, HTML5, PHP, JS, jQuery, Ajax, SQL, Website Development, SQL Server
...authentication. Create the ability to upload and download a standardized excel template that will update a SQL database based rules. This portal will also provide reporting capabilities in the form of a dashboard. Skills: Excel, HTML5, PHP, JS, jQuery, Ajax, SQL, Website Development, SQL Server Requirements: Must be a resident of the US. Local to ...
...exe to read from .csv (excel file) and write into an SQL table. The built program should be able to read all the records from an .CSV file and write them to an SQL Server table. They are 14 fields that need to be read from each record in the .CSV file, make a small translation on each and write that values to an SQL Server table. The translatio...
We are looking for som...looking for someone to build the web application to transfer data into SQL Table from 3 different sources. 1. The user can move data from one SQL Server view to another Table. 2. The user puts web service URL and transfers the data from web services to SQL Table. 3. Upload Excel, CSV or Text file directly into Table.
Needed: Subroutine writen in Active Server Pages (Classic) that copies a dataset from Access (or SQL) to an Excel File. Sub TransferToExcel(rs, OperationType, ExcelFileName, ExcelTabName) rs = INPUT (a open record set (either in Access or SQL) that contains the records to export to Excel OperationType = INPUT ‘N’ for new file or &lsquo...
I am busy building a financial stock analysis website. Database work has been completed in MS SQL Server. Visualization has been scoped and chart and dashboard mock-ups have been created in Excel. I need to know understand the cost of taking this live. I need solution architect to advice on possible solutions for website design and visualization
...use linked Excel files at the moment. We need an instant online remote access to preview, edit and save files. Kind of support: Network Description of support work: We are a small growing building and project management company of 4 departments (one employee per each department) + admin. We have our OneDrive system and use linked Excel files at the