Database manipulation with VBA or Macro's
Hi, I would like a script or program that will split a large TXT file, manipulate the data on each of the 10 split files, and then put it all back together again as a CSV so that I can upload it to my website on a weekly basis. At the moment i am doing it manually and it is cumbersome , repetitive and takes hours. The job itself is simple: FILE 1. 1. Split up a large file (more than 2 GB and cannot be opened by MS Excel due to row restrictions). This can however be done manually if required using Wonderwebware file splitter. Break it up into files consisting of 1 million rows, which will create about 9-12 files. 2. Automate the process of renaming the headers in the first file. 3. Perform some =IF calculations ( i already have these calculations) 4. Perform some find and replace operations 5. Filter out inconsistent data 6. Delete irrelevant columns 6. Convert columns to the correct formats 7. Merge the files back into one large file and upload it. (again this can be done manually if required) I am thinking a VBA scrip or possible Macro program should be able to cover it, as the tasks are simple, and repetitive but consistent, except for the first file which must have the headers. I have the FULL sequence of events documented. There are another two formats that need the same kind of manipulation but would need different sequences of events. FILE 2 File columns vary from the above file. 1. Split the file (as above) 2. open the CSV, using only certain columns which are predetermined 3. Automate the process of renaming the headers in the first file. 4. Perform some =IF calculations ( i already have these calculations) 5. Perform some find and replace operations 6. Filter out inconsistent data 7. Delete irrelevant columns 8. Convert columns to the correct formats 9. Merge the files back into one large file and upload it. (again this can be done manually if required) FILE 3: Onix file - need to get it into CSV format and onto my website (SQL Server 2008) Repeat steps all steps above, but it is a different file format with different columns, so will require its own script. Get the file onto my website
Latest related projects
| Project name/Short description | Project type | Posted time | Budget |
|---|---|---|---|
Update Multiple Inventories - 4 Parts Part 1: Clean Up Amazon Spreadsheet, remove unneeded products, add search terms Part 2: Consolidate 2 Different Magneto Product listing Info into 1 listing Part 3: Add New Products; only for Wholesale (Includes product Info with Images, remove watermark if necessary) number agreed to in PM Part 4: QC consolidated list and new products Full details » | 22 minutes ago | $30 - 250 | |
Project Keystone: Research Assistant Requirement Mission: To create a user friendly web-based database for company internal needs. The database will consist of company names, company bio, company contacts, addresses, website links. Tasks: - To enter existing information about each company, short bio, their key team members, contact details, based on existing information - To research other online databases for the above and classify them. - Plus ... Full details » | 34 minutes ago | $30 - 250 | |
Extract Data From Ms Access And Outlook Backup 2 2 Simple Work: You need you extract data from MS Access database and MS outlook backup (pst file) I'll need the backups according to certain criteria like creation date, tags etc. Easy work: $50 Please do not ask me unrealistic questions like the size of backup (though its 20 MB around), and other details etc. Just for your information, I need to import them into Gmail. Thanks Full details » | 34 minutes ago | n/a | |
Usb or ps2 pos data logger I am searching for a system that i can connect to a POS terminal found almost in every store, usb or ps2 it has to read the magnetic card swipes,3 track hi co.. and store them with date and time. also i need to get the pincode , Could someone help me , is there a system like this. Full details » | 50 minutes ago | $250 - 750 | |
New MS Access Database Design/Creation Marine Services Brokerage International needs a database designed/created. Please find the attached document for project description. Full details » | 1 hour ago | $250 - 750 | |
Agent North America Hi I am looking for an agent in the USA for the following process: to receive address mailings and to send excel sheets and images containing the mailing information on a weekly basis. Estimate volume: 180 mailings Budget is based on 100 mailings . Commencing immediately. Important...you must be based in the USA ! Thanks Adam Full details » | 1 hour ago | $30 - 40 | |
Word Typing Project Project Description: I need serious persons for my Word Typing Project. This is a simple job, but should type accurately. Good typing skills are added advantage for a freelancer. One should type at least 3000 words per a day at least ans should have a commitment towards work to type 3000 words a day. I need more people for this work. New freelancers can also apply, but ensure that they can type 3000 ... Full details » | 1 hour ago | $250 - 750 | |
DATA ENTRY-COPY AND PAST Project Description: I am looking for an individual who can post my 300 articles from one website to another. Fresher may also apply however must be fast in data entry Full details » | 1 hour ago | $250 - 750 | |
Convert Microsoft Access 97 Application to Access 2010 (2) Convert Microsoft Access 97 Application to Access 2010 General Description: Microsoft Access 1. Currently existing Microsoft Access 97 custom application called “Workorder” needs to be migrated to Access 2010. Approximately 45,000 existing parts records, 50,000 workorder records and 5,000 customer records, and others, etc. The following modifications need to be made to Workorder: a. On the Parts ... Full details » | 2 hours ago | $500 - 1000 | |
Data Entry in Microsoft Excel project Description: Hello! We'd like your help in getting 607 contacts in an Excel file. The information is retrieved from a website (we'll give you the login details later). The addresses can be accessed by just a few clicks (click name, go back, click new name, go back …). See screenshot 1 how the addresses appear. See screenshot 2 how we need it in Excel format. We need NAME, CITY, PHONE, EMAIL, ... Full details » | 2 hours ago | $250 - 750 | |
Manually type old books Project Description: Hello friend, We are currently in process of digitizing older books ( stories, newspapers etc) . And we need a good typist with proper knowledge of MS-Word . We will provide you with about 30 scanned pages which are in jpg format. Please don't use any OCR programs. You need to manaully type these documents into doc file. And also proper formatting ( bold, italics, underlines ... Full details » | 2 hours ago | $250 - 750 | |
Experienced Classic ASP Developer WANTED!!!! XML & SQL 2008 Need experienced Classic ASP developer with core knowledge of XML & SQL 2008. Responsibility of developer is to establish connectivity using SQLXMLOLEDB.4.0 & SQL 2008. Prior to awarding this project, would like see the following working script on your server: http://msdn.microsoft.com/en-us/library/ms171785%28v=sql.105%29 You may create dummy application as per provided link and demonstrate it ... Full details » | 2 hours ago | $250 - 750 | |
| 2 hours ago | $250 - 750 | ||
List of Clients I am trying to compile a list of potential clients. These clients will be any company that ships a lot of products online, but based in Los Angeles. This list can be scraped off of ebay, amazon, or any other sites or sources you see fit. This list should be in excel format, and should contain the following: Business name, website, address, phone number, contact agent a big plus, and description of ... Full details » | 2 hours ago | $250 - 750 | |
Siple data entry/PDF to MS WORD data entry Hello, welcome here for very simple data entry work.You have to type images which is shown only. This is very simple data entry work and i am invite new freelancers also to do this kind of the data entry . I am giving u instruction about this work and u can easily done this job. and this job u will get 100% guarantee work and payment.If u complete my test then u will be selected as the winner ... Full details » | 2 hours ago | $30 - 250 | |
daily 100-1000 downloads , Earn $10-$100 every day Please don't bid if you don't have experiences to complete this work our terms are : - you will make real people downloads 100-1000 daily using our link - they must be real people - it is exist survey process before download to be completed - you will be paid $0.1 for every successful download process - we need 100-1000 daily , then you will earn $10-$100 daily - You must prove your ability for this ... Full details » | 2 hours ago | $30 - 250 | |
Virtual assitant (Girls only) Looking for a FEMALE VA (part time) with CAM, should be proficient in English, Friendly & be available when called. Requirements: ------------------ * Female * Age 18+ * Open minded & friendly * Self starter * Be on time when called. * Should have skype * Should have cam * Proficient in English ( you don't have to be fluent, but proficiency is a must! ) ONLY APPLY FOR THIS JOB IF YOU'RE COMFORTABLE ... Full details » | 3 hours ago | $15 - 25 | |
Data Entry Assistant Needed Asap, will hire the first qualified person. I need assistants to help me process my online job at home. The task is very simple and you can decide when to work and for how long. The requirements are to have a computer, an internet connection and the ability to type fast and accurately. I prefer mothers who stay at home, parents who need a second job, students who need part-time job and people ... Full details » | 3 hours ago | $250 - 750 | |
80 business directory submissions We will supply a list of 80 business directories that you can sign up to under our name and submit our Url, address and tel number. 30usd please. Each directory has to be visited individually and each submission is manual, no software submissions. Full details » | 3 hours ago | $30 - 250 | |
Home Based Typist require Home Based Typist/Data Entry Clerks Positions Available. Apply now, Worldwide Openings. Work from Home without investment. We offer Online Data entry jobs, Offline Data Entry Jobs, Free Data entry jobs,Typing jobs, Work from home jobs, Part time jobs, Freelance Data entry jobs. In this positions you may earn $500 -$1000 weekly. new freelancer with low rate most welcome Full details » | 3 hours ago | $30 - 250 | |
Coupon Submissions 500 for $50 I need 500 coupon codes submissions on different coupon websites. The higher the traffic of these sites, the better. I need you to first send me a list of the sites you plan to submit to. Once they are approved, you can begin submitting, but will need to provide daily reports that include the links showing where the coupon has been posted. There should not be no more than 3 submission per site. In ... Full details » | 3 hours ago | $30 - 250 | |
Database Implementation This work incould two part. PartA:SQL Queries. For this part of the task you must carry out your queries against the set of tables which have been created in the Oracle database by a user called SPORT who has granted you SELECT on the necessary tables. Part B Part B - Data manipulation/PL SQL/Design. u can see more detaild by downloading the file. i just want get this assignment back no later than ... Full details » | 3 hours ago | $30 - 120 | |
Basic software program with print receipt and report Dear sir, I'm looking for someone develop my personal account. Program Requiement 1. Login (only 1 login for me) 2. using MS Access with password to access. 3. Can be use VB or any languages (window app.) Concept 1. Our company is account company, but this program is running for myself only to monitor income/expense 2. We already have sample database (using MS Excel) 3. We need design program ... Full details » | 3 hours ago | $30 - 250 | |
Data Entry Of 550 Products Into Excel For Magento Import We need someone to go through our ebay store category by category (we will supply order of categories to do) and create an entry for each product in our spreadsheet format for each product and size variation. it will include title, description (cut and pasted from eBay), price, and amounts available in each size etc. There are about 550 products and at least 3/4 of them have several size variations. ... Full details » | 4 hours ago | n/a | |
I NEED U TO CREATE A VIBRANT,EASY FORM FOR CLIENTS BY TODAY! I need someone who can create a SIMPLE form for me, I did a basic one on Word but I will send to you and you can create a vibrant, easy to complete, simple client profile form for me. I am a personal trainer and have a series of questions to ask my clients, which I EMAIL them, they fill in and SEND BACK to me via email. I expect this is an easy job for the right person, so it won't be a lot of money.....I ... Full details » | 4 hours ago | $30 - 250 | |
Calendar Viewer/Editor there are right tabs in the right panel: (1) Views (2) Admin Tasks (3) Help. ‘Help’ is done. the Views tab shows view of enviornment calendar based on the widget that shows monthly & quarterly views. currently the data for this view comes from hardcoded data within the widget. this should actually come from the data in sqlite db. when you click on any item a popup window comes up showing the details ... Full details » | 4 hours ago | $250 - 750 | |
Data Entry Work For All hi this is very simple typing work at minimum target and also with high rate This is Easy work and also best for New Freelancer Worker I need you type 1000 - 3000 word/ day in 7 day Thank you Full details » | 4 hours ago | $30 - 250 | |
Webscrape Website 5 I would like to have the attached two websites scraped and the data entered into two different Excel spreadsheets. See attached file for complete details. Full details » | 5 hours ago | $30 - 250 | |
Manual collection of e-mail addresses from Yellow Pages I need someone who can go to yellowpages.com and search for "gym" in (1) New York, and (2) Missouri. You then need to go to each gym's website and get the e-mail addresses from each site. They must be local gyms - no huge corporations. You then put them in a normal text file (each e-mail on separate line). Each e-mail will be personally verified by me. 800 are needed A.S.A.P. Thank you. Full details » | 5 hours ago | $30 - 250 | |
simple excel analysis Hi There, I believe this is a very simple project I currently have a range of data that needs to be analysed on a 6 monthly basis and then graphed. Which we then use to create 9 reports of various geographical precincts. At present the files are satisfactory and I have done the best with my limited excel skills but I am hoping there is someone available to clean the spreads and possibly make them ... Full details » | 5 hours ago | $250 - 750 | |
Need to modifiy GUI and code of existing software (VB6) I am looking for someone to modify and to make changes to existing application created in vb6, I will provide source code to selected bidder. It's basically task scheduler application. No need to any new feature, I want you to check each functionality of the application, modify GUI, make it error free, make it more user friendly. for more details PM me. Thanks Full details » | 6 hours ago | $30 - 250 | |
Developer Visual Studio and Light Switch I need a expert developer to manage data in SQLEXPRESS.. To create windows forms to manager (add/edit/delete/customize) approximately 17-20 tables Only applies if you work with Visual Studio 2010 and Light Switch, If you don't manage this programs please do not bid. Full details » | 6 hours ago | $250 - 750 | |
Email Database, Investors in Commercial Real Estate I need a list of commercial real estate investors for Pennsylvania. Specifically will need high importance on the Philadelphia area. The goal is to expand our database with acquisition and disposition departments. We are looking to find developers, NNN investors, retail investors (single and multi-tenant) and apartment investors. We need the contact name, email, phone number,address and title of ... Full details » | 6 hours ago | $15 - 25 | |
R Language data processing and graphs (R language only) There are some data sets to be processed using R Language and presented in graphs. The data set is simple and no much. But it is required you process it using R language. Please PM me and I will attach the data file for your review. Full details » | 7 hours ago | $8 - 15 | |
Google Adwords Data Scrapper 2 I would like someone to build a tool that can go to : https://adwords.google.com/o/Targeting/Explorer?__c=8337484959&__u=9278523159&__o=cues&ideaRequestType=KEYWORD_IDEAS and collect the data, It must be build on C#, C++ or VB. I want to be able to call a function, like this : Adwords.Scrape("keyword here") that keyword would be inputted and the results returned back ... Full details » | 8 hours ago | n/a | |
Widget Style Formatting This is a hopefully simple and quick project. It requires HTML and if necessary, Javascript. No other scripting languages please- needs to be reletively basic. Script must be able to be executed off Amazon S3, so that means there is NO serverside processing (non-dynamic/static JS & HTML files are client-side only!). Also, a wysiwyg html editor like TinyMCE (opensource), and a color picker like ... Full details » | 8 hours ago | n/a | |
Typist/Data Entry Clerks Positions Available Home Based Typist/Data Entry Clerks Positions Available. Apply now, Worldwide Openings. Work from Home without investment. We offer Online Data entry jobs, Offline Data Entry Jobs, Free Data entry jobs,Typing jobs, Work from home jobs, Part time jobs, Freelance Data entry jobs. In this positions you may earn $500 -$1000 weekly. new freelancer with low rate most welcome Full details » | 8 hours ago | $250 - 750 | |
USC email list I have a list in word that I pulled from a USC website. When I pulled it into word it just came in as a huge block and I can't extract the email address from it. I need someone to pull only the email addresses and put them in a excel spreadsheet. The list is fairly long but includes names and physical addresses but I only want email addresses. Full details » | 8 hours ago | $30 - 250 | |
Pull Yext.com Reports For My Company http://yext.com I need someone to pull 100's of Yext reports for specific business categories. Instructions: #1- Visit yext.com #2- Add business information #3- Run report for all 30+ directories #4- Scroll "screen shot" the results #5- Remove yext branding #6- Convert to a PDF WATCH THE VIDEO URL SHOWN IN THE ATTACHMENT. PLEASE BID FOR DELIVERING 100 REPORTS. I REPEAT ... PLEASE ENTER YOUR BID ... Full details » | 8 hours ago | $30 - 250 | |
Content writer for website (Native writers) required We are looking for content writers (preferably native ) . we need content for our website which is similiar in operation to http://freshdesk.com/ the writer will be responsible for writing all the content. The content should be professional and should make complete sense. Humor factor can also be added. the work will include page contents for Main page punch lines FAQ contact us some blog ... Full details » | 9 hours ago | $30 - 250 | |
Build Contact List in Excel Spreadsheet from Website I have a website that I need data transferred from and entered into an excel spreadsheet. I will provide the spreadsheet and the website. The website is a map with locations. You will need to click on each location and enter data provided. There will be approx 350 entries. Please leave a quote and time frame. Thank you. Full details » | 9 hours ago | $2 - 8 | |
50 PR5 backlinks needed for new website I want for only $35 dollars 50 manually submitted, following all of Google's guidelines (white hat) PR5 backlinks. Keep in mind, the website is newly build and recently submitted to Google therefore it is not even listed anywhere yet. Whoever could deliver this, place a bid. If everything goes well, many more will be requested. Full details » | 9 hours ago | $30 - 30 | |
amazon inventory expert, Hi, I am looking for some one who can copy product form my one account and add to another account.. This is long term work, I am only looking for people who were able to done in automatic way like inventory loader file or with inventory report or csv file. Please don't apply if you are looking for manually work.. Have a great day, Thank you, Full details » | 9 hours ago | $2 - 14 | |
I need list of at least 500 app sites I need a list of at least 500 app review and app directory sites around the world No bid more than 30$ will be accepted all sites links should be delivered in excel sheet arranged alphabetically(ie. put sites starting with A in the A column and so on ) Full details » | 10 hours ago | $30 - 250 | |
Large Dbase database to web project I can do all the graphics in a psd I need a programmer an it to help with the rest. There are several pages that are informational that I will need to upload pdfs and files to as well as text. I want to be able to input the information. Then there are two dtabases that people come in and fill out theior event information. It is then searchable to others by location and type (4-5 types) and date. This ... Full details » | 10 hours ago | $250 - 400 | |
Excel work...find parentheses and text then delete Attached is an excel document with 2 columns. Within each row, there are words in column A which are sometimes repeated in Column B, (of their respective row only). We want to duplicate those from B into a new column, but without those terms from Column A. So, in other words, find a row, use the exact phrase in column A, if found in column B, then to copy all the terms in column B except those terms ... Full details » | 10 hours ago | $2 - 8 | |
Dance Academy management Description- It is the Stand alone Software created for dance academy. Front end is VB.NET Backend is SQLEXPRESS 2005 Application: ADD,UPDATE,DELETE Records SEARCH Records MAINTAINCE OF BATCH RECORD,STAGESHOW RECORD PROVIDING COURSES Full details » | 10 hours ago | $750 - 1500 | |
Data entry for web site The project is typing in restaurant and menu data for a web site. The entry will require data to be loaded in multiple screens. You will need to be able to navigate a web site to validate the entry of the data. The data will come from a document, PDF and websites. There are a minimum of 20 restaurants to be loaded along with their corresponding menus. One entry = one hour. You need to be able to ... Full details » | 10 hours ago | $2 - 8 | |
AutoMate Project for Service Engineer AutoMate provides an incredibly easy-to-use, drag-and-drop, intuitive interface for developing automation applications. The basic plain-English, drag-and-drop, fill-in-the-blank building blocks are used to build AutoMate Tasks. and yet I still need help fixing this "plain English drag and drop solution for opening and closing tickets. Sample all GUI driven AMPRESS WINDOWTITLE="Self Service Portal ... Full details » | 10 hours ago | $250 - 750 | |
Different Language Travel directory submitting Need candidate from different language who can find potential good ranking 20 travel web directories/blog from there language and enter a write up we give in the language to the website. it should be entered on proper place where it is allowed to enter for free. dive center directory , dive blogs , travel company directory, travel blogs and any other . all the 20 website link should be send to ... Full details » | 11 hours ago | $30 - 250 |
