Cancelled

Write small program to correct fields in MS Access tables

I have a simple 6-table Microsoft Access database that I periodically download certain financial data from Yahoo Financial into. The data is financial information about publicly traded companies. Some of the fields are downloaded into my database in a form other than numeric data, which results in an inability for me to sort or filter on the field. For instance, a percentage might be stored as "[url removed, login to view]%" complete with the percentage sign, stored as text in the field. Or a dollar amount might be sorted as "$[url removed, login to view]" complete with the dollar sign. I cannot just fix the data one time becuase I periodically receive updated downloads and the data being downloaded is formatted as text with this issue. Therefore, I want to have a program written that I can run against the database each time I perform the download to "clean up" the data in these fields.

I will supply the single database file with a relatively small number of records in the file to make the file smaller and easier for you to work with. I will supply the list of each field in each table that I want converted. Most will be to eliminate dollar signs and percentage signs. I have not looked closely at the quantitiy of fields but there are less than 50 total fields of data in the entire 6-table database and probably around 20 to 25 fields need to be converted.

I expect this project will involve writing a simple program that reads all of the records in each table within the database, and for each field that I list as needing to be converted, trim off the dollar sign from the front and/or the percentage sign off the back, and write the record back to the database.

The workproduct needs to be the actual program that will look for the subject Access database file by name in the same folder in which the program you will write resides and run and operate as I described above. I want the source code so that I can made changes to the fields if necessary, as it is possible that the company I obtain the downloads from might change the field names or database structure in the future. I prefer the program to be written in VBA or another standard language in case I need to have it changed in the future.

It should be an hour or so of work for someone that is an expert with Microsoft Access and VBA, or a little longer if you must figure it out.

Email is the best way to reach me. I'm fine with working with anyone anywhere in the world but I can only communicate in English.

Thanks.

Skills: PHP, Software Architecture

See more: writing change world, writing file, writing tables, writing standard form, writing names, write names, vba world, tables data structure, structure writing, source code program php, small writing table, simple dollar, php program download, access writing, ms companies, want write english, expert microsoft access, email writing english, data structure sort, correct way writing, best data structure, access database expert, in vba, want sign, best case software

About the Employer:
( 7 reviews ) Sugar Land, United States

Project ID: #1281478

14 freelancers are bidding on average $81 for this job

srinichal

I am ready to deliver

$120 USD in 4 days
(134 Reviews)
7.3
intechwebworks

Hello Sir I can do this task please check PM! Thankyou

$85 USD in 1 day
(42 Reviews)
6.3
MustafaSR

Hello sir, Please check PMB

$50 USD in 2 days
(83 Reviews)
5.8
wsh2

Greetings Texas from Pennsylvania.. 25+ year MsAccess programming expert with excellent data transformation skills and experience. Degreed accountant very familiar with financial concepts and terminology. Am More

$50 USD in 1 day
(9 Reviews)
5.5
Krusche

This can easily be implemented. Please check the PMB.

$60 USD in 2 days
(3 Reviews)
4.5
lproduce

Ready to help you.

$30 USD in 1 day
(6 Reviews)
4.0
instech

Please see the PM for my comments.

$90 USD in 1 day
(2 Reviews)
3.0
davidt999

Hi! I can do this for you. Please see PMB for a sample of my work. Thanks! David

$35 USD in 1 day
(1 Review)
2.0
jsb80427

hello sir. pls look at your pm.

$100 USD in 3 days
(0 Reviews)
0.0
nitesh1952

I am very well familiar with the Excel VBA Programming and I assure u to to complete this project on the specified time as per the requirements.

$50 USD in 2 days
(0 Reviews)
0.0
contact2haseeb

I am very good in MS ACCESS. Give me chance to do this

$30 USD in 1 day
(0 Reviews)
0.0
ehabradwan

Hello, kindly check PM

$100 USD in 5 days
(0 Reviews)
0.0
ExactSystems

Please see detail on PMB. regards

$80 USD in 2 days
(0 Reviews)
0.0
NMSProjects

I can do this for you. I will use Visual Basic and ADO.NET. My price includes ongoing maintenance for one year. If fields change, I can fix it for you during that time. I am in Alabama, USA and on CST and can be avai More

$250 USD in 5 days
(0 Reviews)
0.0