Convert excel with multiple text columns which require parsing into multiple row entries for loading into access or SQL server database. There is a standard delimiter used in all columns of text data. Provide SWL statement for use with future data.
...entry. I need to convert this into a website that can be sorted, filtered and searched like in Excel. Also need the ability to import CSV files to add to or merge with the existing data if it already exists. Ability to export refined search data as CSV files. Ability to assign users their own username and password so I can revoke access to it. Ability
Excel Pivot to Access Database Conversion Project I want to take the existing Excel document with pivot tables and convert it to an Access database, but with the addition of pulling the data from the [login to view URL] report: 1 Named Account Portfolio Planning (in [login to view URL] as “[login to view URL] Account Portfolio Planning”). A sample...
Needs to hire 3 Freelancers We are currently seeking an experienced team (or multiple individuals) of analysts , Excel experts, and possibly data scientists, to manage a large portion of our daily analytical work. Work load is variable, but could exceed 40 hours / week at times, depending on the season. If successful, the team will have consistent
Hello, we are currently using an excel spreadsheet to do NAV calculations for a Hedge Fund. We would like to automatize this task as most of the parameters are fixed . The goal would be to enter the assets of the fund, convert those into a base currency, calculate fees/charges, performance fee and NAV per share. Ideally the program should also deal
I am trying to convert an existing excel and SharePoint based functionality to be cloud based. The expectations are: 1. Provide a user interface with possible drop downs where possible to enter data (Around 25 fields; 10-15 drop downs which will be provided) 2. Dynamic changing of field labels 3. Notifications/Workflow functionality 4. Store this
...point this data to pre-fill various PDF documents, and translates data to AL3 to import to Vertafore's AMS360 Online database. Applicant must have skills to convert data from Excel or Access formats to insurance tech format AL3 (by ACORD). We have about 1-2 weeks before we select the capable specialist, however, if you really know what you are doing
I will give you excel file and I want to convert it to chat conversion The data which entered in the chat conversation shall be saved in webpage or excel file The data filling shall work on any smartphone browser. . You shall use the below open source project [login to view URL] The project shall achieve
...well as database structure are parse correctly. Once all live feeds are properly save into the SQL databases (automated). Assist Client setup Online SQL connection (API) & access as well as SQL server (desktop). Ensure the most updated live odds feeds are always updated into the SQL database. This is the backend project in preparation for future front
I need to convert my excel file data filling into chat conversation. The data filling shall work on any smartphone browser. The data shall be saved in the smartphone and uploaded when internet access available. You shall use the below open source project [login to view URL] The project shall achieve
...installs. I need to do the following for the "Master Sheet" - Convert to a centralized DB (access, SQL, etc.)that will be housed on my Virtual Machine (azure) so that everyone with the excel file gets updates - I don't want anyone to have to download/install any software besides excel - Form to enter/edit the information - Track recent changes
I have several excel data sheets and my file is growing. The data should be kept in a Database rather than in Excel. I am familiar with using Access but i don;t have the time to set up the relational database, forms and reports.
I need to convert my excel file data filling into chat conversation. The data filling shall work on any smartphone browser. The data shall be saved in the smartphone and uploaded when internet access available. You can use the below open source project [login to view URL] The project shall shall acheive
I need to convert my excel file data filling into chat conversation. The data filling shall work on any smartphone browser. The data shall be saved in the smartphone and uploaded when internet access available. You can use the below open source project [login to view URL]
I need to convert a Forum application from Classic ASP (Access database) to ASP.NET (MSQL database). Rather than a Forum we could talk of a Q&A (Questions and Answers) application, in fact users (Windows Authentication required) based on the Authorization profile (defined in a database table) can post questions and other users have to answer these
...tools like Firebug, Chrome inspector, etc. -Ability to understand CSS changes and their ramifications to ensure consistent style across platforms and browsers -Ability to convert comprehensive layout and wireframes into working HTML pages -Good understanding of PHP back-end development -Familiarisation with any frameworks (bootstrap), libraries, or
my resume is done in word format, I want to convert it to infographic design and to match the job I want to apply for. I am a chemical Engineer and I am applying for In-country value job Job Description : Purpose of Job As a member of the In-Country Value team you will: •Be part of EVD Graduate Development Program (GDP); to help you
...someone who can write a program that I can import from an excel data source, analyse check, underline, highlight and provide a report in PDF for distribution to staff the grammatical, spelling and gender errors using a predetermined dictionary (Australian) identified in the text. The program will convert the information to a PDF that clearly identifies where
Currently I have an Excel VBA that scans over a folder of excel files. It adds a template sheet to it that analyzes the data in the files. The files in the folder are all formatted the same. The VBA reads all the files in the folder. Then records the output in the VBA output tab. The conditions tested are variable. I need to convert this script to python
...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 in Michigan (about 4,500 families). Step 1: Document procedure to import the access data directly into
Hi Prashant S., I noticed your profile and would like to offer you my project. It is a project to convert a multi sheet excel workbook into in an Access database. It has lots of formulas and it quite a big job. Are you available? If so can I have your email to send more detail to get a quote.
...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 ‘A’ to a...
...would like to be able to convert from an excel spreadsheet to a access database. We have a consolidated matrix and an individual location matrix .. i would like to be able to build the master matrix and be able to import data from the location matrix. I will provide the excel spreadsheets to the winning bidder, The excel spreadsheets already give
I have 2 pdf files and i need you to find or make a tool that can convert the text to excel sheet and write rules to arrange the text in a sequence in Excel. Check the link to access pdf files: [login to view URL]
I need an Android app. I would like it desi...data of devices installed at site as new sales and service. The data should be downloadable in desktop with facility to convert into excel table format. Dealer / user must be approved by app admin and should only be able to access and edit data submitted by him only. App should be very compact in size.
I need an assistant to convert a data table in csv format into another format. Needs to have good communication skills and access to Skype or Audio/Video tools on Freelancer. Please don't qualify. It's a bonus if your based in the US. Rising stars who qualify please apply. If you have any experience with R, Excel or Rstudio with good written
I need the Excel sheet as mentioned, to be more systematic hr audit checklist using Microsoft access able to compare the data, analyis, identify area's of risk, and create individual dashboard and Group Dashboard and comparison something like the attached [login to view URL] [login to view URL]
...Developer to build a custom database for a garment manufacturing company. Currently, the company works off spreadsheets via MS Excel and Access and would like to convert these into a user-friendly database system. Excel and Access are used to do the below: Report files: Wip report Cutting ticket report Commercial invoice report Costing report Fabric repo...
For some non technical guys is needed to have the firewall configs translated into an excel sheet with all the names and groups expanded to a IP/port level. The script should also convert the nat entries and static routes. The firewall is Cisco ASA. i can provide a sample config, but the development must be done on your side. the object names are
I am looking to convert a Google Sheets document (Excel) into an online database. It will need the functionality to create new weeks at the click of a button whilst saving existing data. It will require username/password access with the facility to add/delete users with two types of access: user/administrator. User will be able to enter information
We run a small business and we would like to convert number of excel data bases to MySQL. One of these will need to link to our word press website. I have created a project using MySQL Workbench to show how I think the data base should be set-up. Would start with one project to see how it goes. We sell products that are tested [login to view URL]
I am looking to convert an existing Excel-based property management system to a Microsoft Access based application. This is a fairly complex, customized development project so I invite you to ask questions and clarify as much information as needed before bidding. I tend to ignore bidders who send over canned responses within 30 seconds of posting.
PROJECT DESCRIPTION I am looking for an Android app developer that can convert my excel spreadsheet into an iphone/android app. There are some variables and simple formulas but no VBA code currently built into the spreadsheet and is mandatory in order to operate correctly. Part of the job will be to ensure the app is clean and suitable design wise
...that can convert my excel spreadsheet into an iphone/android app. There are some variables and VBA code that is currently built into the spreadsheet and is mandatory in order to operate correctly. Part of the job will be to ensure the app is clean and suitable design wise. We have an exclusive network of clients who we would like to have access to this
...looking for someone to help me set up an eBay File Exchange Excel sheet for use on eBay UK. I have developed an Excel sheet to help generate listings but, when I convert to data to the File Exchange format, I keep getting errors and it is driving me insane!! I have supplied an excel sheet with some raw data, plus where I tried to use a category
...description of this project: I am looking for someone to help me convert simple excel calculators to a format that I can easily use on my wordpress websites. I don't know which coding language is required for this (I guess php can do the trick). I will always provide you with a working excel calculator, including all input fields/dropdowns/..., the tables
This project has three parts: 1. Convert an Excel form to an attractive HTML/CSS form. 2. Insert the data into a SQL table using classic ASP script. 3. Load the form with data from a specific row. I have attached an Excel spreadsheet that is has a form to collect data. I would like you to convert this form to an attractive and functional
The project has as its starting point an Access database with Forms and Queries. Everything must be converted into a web application made in asp.net (VBNET) based on SQL Server. The application is used to import 2 excel files, after that some queries are executed to update values in tables. At the end of imports user can use different 6 queries to
...i need to make a system who will take all my bills from phone company and convert them in to PDF report. Bills comes in a text form. From that bill you need to separate, all the payments and services and after that you add people names and have a report. So there is 2 excel tables, 1st one is all the numbers and bills and 2nd one is all people names
I need to convert the attached spreadsheet into a simple MS Access 10 database. No executable file, just plain Access. Relationship should be 1toMany. My idea is a main panel where you can chose at least two options: Data entry, Reports. The Form for data entry will offer the ability to add 1 or more "subjects" for each "victim". The reports should
I have a macro developed in excel to read from two work sheets and provide the result in a new one. This logic I want to convert to MS access, to read from 2 tables and run the result into the new one (Through form).
Hi there I have a 2003 microsoft access file that I need to open in the latest access software, but I would also like a copy of the data downloaded to an excel file. I would like the job done straight away so please dont apply if your not available. Regards