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 "1.23%" complete with the percentage sign, stored as text in the field. Or a dollar amount might be sorted as "$100.00" 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.


Skills: PHP, Software Architecture

See more: writing to change the world, writing to a file in c, writing tables, writing in standard form, writing in names, write names, vba world, tables in data structure, structure in writing, source code program php, small writing table, simple dollar, php program download, my access writing, ms project expert, ms companies, ms access with php, make 100 an hour, list in data structure, i want to write english, i want to write an email but i need someone to correct it for me, i can write my name, expert microsoft access, email writing in english, download c++ program

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

Project ID: #1281478

12 freelancers are bidding on average $83 for this job


I am ready to deliver

$120 USD in 4 days
(151 Reviews)

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

$85 USD in 1 day
(44 Reviews)

Hello sir, Please check PMB

$50 USD in 2 days
(86 Reviews)

This can easily be implemented. Please check the PMB.

$60 USD in 2 days
(3 Reviews)

Ready to help you.

$30 USD in 1 day
(6 Reviews)

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)

hello sir. pls look at your pm.

$100 USD in 3 days
(0 Reviews)

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)

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

$30 USD in 1 day
(0 Reviews)

Hello, kindly check PM

$100 USD in 5 days
(1 Review)

Please see detail on PMB. regards

$80 USD in 2 days
(0 Reviews)

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)