I have a dataset of [url removed, login to view] records (id, reference) stored in comma separated text file, Each ID is associated with 1 of 5 references. e.g.
I have a web version of a tool using php and MySQL that when you type in an id will return a web address based on the reference. eg.
A,[url removed, login to view]
C,[url removed, login to view]
L,[url removed, login to view]
R,[url removed, login to view]
S,[url removed, login to view]
What I need is a standalone version for offline use. I had set up an excel spreadsheet where the user enters the ID and is return the URL via a VLOOKUP in a VLOOKUP but unfortunately excel will only handle 1,048,000 rows and at the moment the dataset is [url removed, login to view] rows (and 30Mb).
The application should not 'install' anything into the client PC.
The data is likely to be updated quarterly so this will need to be reusable.
Please explain how you will approach the solution rather than simply say you can do it as I do not have time to waste - otherwise I'd google a solution!
Hi, I can write a macro in Excel that will overcome the 1048576 row limitation Let me know if you're ready to start .....................................................................................
11 freelance font une offre moyenne de $59 pour ce travail
Hello! With 99% completion rate, 740 successfully completed projects, and a 5.00 reputation (maximum possible, 5.0) (Yes, not even 4.99 average rating, can be verified on my profile page https://www.freelancer.com/u Plus
Hello, I can write a Perl application that will handle the csv file as a database. Perl has library to handle this. I will provide a simple GUI and have it compiled it into an exe, and need to be deployed on any Plus
Hi. Simply spread the data across multiple sheets and use a VBA script to find look up value. Its pretty simple. Please discuss if you are interested. Regards.
Lets start. Having a team of Professionals. We provide high quality work with accuracy. Would you like to discuss more about your current requirements?
PREFERRED FREELANCER -------- Windows and web based application developer -------- Highly quality output based work. ----- PM to discuss. Regards, Nick
we can code a c# application to parse through your csv file and populate the values.... please reply with your huge excel file.... thank you...
Good evening, I'd use Delphi and codebase dbf database. it's the fastest way to do a look up in a dataset; then a simple form with an input box and a button. on enter the Id I lookup the reference then if you wish I'd Plus
Hello, I think I can do the project. I would like to write a macro that reads the data to excel sheet - split the file into parts, and write in columns. The first part of the data in columns "A - B", another in col Plus
Hello, Not really a good idea to use Excel for 2.5mil records dataset I would say. The data should definitely be stored in some kind of database. I can build a simple Java application. It will use sqlite database Plus
I have worked extensively in Excel specializing in VBA and automated data transformation for 10 years. I have completed many tasks just like this at my prior employeer. My process here would be to design a excel bo Plus