its about database works.. some programmer used sql but we used excel as desame.
...(IFP) is a software program that will run on a cloud Windows Server that periodically scans a dedicated input folder for Input Files (Excel, CSV), parses and validates the files for field data, adds the data to a SQL Server database, and moves the files to a dedicate archive folder. The Input Files will be received from a secure FTP transfer. See
I'm looking to hire a part time (10 - 15 hours/week)resource, who will be able to write codes in Excel VBA and MySQL and will have in depth knowledge of developing a SQL database. There is no specific project. This person will be given the projects on the go and will be expected to meet deadlines and suggest improvement to the current company processes
Hi Le T., You completed a great project for me connecting an Excel sheet to a SQL database. Within the same sheet I have a search function that I would like to improve. Currently you enter some text into a cell and then press enter. Then have to click back on the drop down box to see what has been found. The search function searches a number of cells
...management software - goods in, goods out, 3 user levels ( admin, manager, worker), reporting engine ( must bea easy to add new reports by admin, by inserting sql queries - export to web view/html and to excel), printing out labels after work oderd (goods out) is completed Timestamping every action Audit log on every action(adding, deleting goods etc)
...provided, however can be altered to suit as you see fit. I have started to create SQL statements on each category and product and pricing however have run out of time, I consider this to be a fairly quick exercise for those that have experience in automation in Excel. Upon successful completion of this data migration will lead to more work for the
...Qualifications: Hands-on experience administering [url removed, login to view] Expertise in working with large sets of data in systems and spreadsheets Strong MS Excel, Access, SQL skills Moderate to advanced VBA for Excel Ability to work with data import toolsets (training available on specifics) Experience with Customer Relationship Management software, including
...to run Office 365 ProPlus. The client has Access databases that need to be run in the cloud. Microsoft Access Application front end will sit on RDS server and connect to an SQL server hosted in the same data centre. The deployment does NOT need to be the full high availability set-up and a single VM is all that is required. No data other than the
...knowledge of database languages (e.g. MS SQL) • Understands data modelling, application development and/or testing methods and applies them independently. • Conducts simple tests, application and/or data model developments independently • Good knowledge of MS Office Tools (especially Excel) • Onsite present is must at least for
...Data Scientist required to complete a project. Required Skills: . Experience in Cosmos and Scope is a big plus • Working experience in R or Python is a big plus • Good SQL & Excel skills to troubleshoot data mismatches and comparison • Must have experience in Big data environment • Experience with PowerBI is a plus • Experience with Adobe SiteCatalys...
I have a SQL Server DB that contains tables for Customers and billable items. I need the capability to generate and email invoices using a report builder like Crystal Reports. The solution does not have to use Crystal Reports. I have stored procedures that generate all of the data for the invoice. An excel version of the invoice is attached. The
Hi! I need someone to set up a script that can be run from Rstudio (mac computer) to automatically scrape data including odds data from [url removed, login to view] or...games played between December 1, 2016 and today are scraped) -Odds data: all over/under data for both full time and half time. Output of the scraping should be the excel file or sql table.
...developed as a ‘proof of concept’ in Excel and SQL, and expertise is required to improve the efficiency of use, and output reporting potential of these systems, and to address any new requirements. Typical systems we are looking to integrate and work from include Excel, Access MS Project, Microsoft B.I, Tableau, Oracle SQL, and industry standard ‘...
...need a SQL database running on mysql that I can populate tables from Excel. Each table will be 1 tab on an Excel file. When a tab is uploaded to the SQL database it is to replace all data within that SQL table. This needs to be password protected with an admin level user. The second half of the project is I need to be able to add to Excel files a
...project timelines, milestones, and costs associated with it, I need this to be started ASAP how much time will it take to finish this project. Environment: Windows Server 2016; SQL Server 2016; C#.NET Framework 4.6 or later; responsive design Requirement: New web application will have Single Sign-On with 3 main areas 1) Education videos 2) Questionnaire
...pribadi untuk testing - Pembayaran per fase yang disepakati Scope of Work: - Android Apps untuk Phone dan tablet (Optimize UI dan UX) - Backend ASPX (Responsive) - Database SQL - API Integration dengan Server Internal - Hanya development saja Brief: Ini akan menjadi aplikasi sebuah perusahaan yang bisa digunakan secara luas (public). Kegunaan
about 12 main subjects with about 2...subjects with about 20 attributes and their count and amount in excel ready. you help me to produce a desriptive data analysis statistics good visualized for a paperwork. some interpretation of the results and whats possible with that datas. its not much work. youll get the datas ready in excel or sql if you want.
I have multiple spreadsheets with various information that i need consolidated and re...information. There are about 13k unique records that will be loaded onto 5 sheets. These records will come from a list of about 30k records. It will require great skill in Excel and possibly SQL and Oracle. The output will have to be explained in detail later.