Find Jobs
Hire Freelancers

Importing text files to MS Access

$250-750 USD

Completed
Posted over 8 years ago

$250-750 USD

Paid on delivery
There is a button in the form "frmPatientDetails" which needs to open a dialogue box and import information stored in text files. The first few lines of the text files imported need to be removed so that only the columns of numbers are sorted into the tables. The files need to imported to specific tables. XXXXX_PTV1 will go to PTV1 table, XXXXX_PTV2 will go to table etc. The files named XXXXX_OARs are different because they has multiple sets of data. The set of numbers have a structure labelled before the numbers. I need the data with "Structure: Small bowel" to go to the "Small bowel" table, "Structure: L Lens" to go to the "Left Lens" table the same for bladder, pituitary etc. There is some code already written for this button which opens a dialogue box to select files. There is also some code written which imports some of the information to the mentioned tables. However, it only works correctly when a comma ( , ) is used as a decimal separator (which i have to change in the "change date, time and number formats" in the control panel settings. I need the import to work when a period or dot ( . ) is used as a decimal separator. You can choose to alter what code is there or write something different. If you need to login to the database the password is 1234 for most usernames. The files are too large to upload so they are stored in this dropbox link: [login to view URL]
Project ID: 8495023

About the project

4 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hello, I'm a developer with over 5 years of experience. I work for Pratt and Whitney Canada where i'm responsible for process automation with tools like Access and Excel. I have extensive knowledge regarding C#, VBA, ABAP and T-SQL language i'm also proficient with databases like SQL server, Access and My Sql. If you find this offer interesting please contact me or if you want i could prepare a short presentation for you of what can i offer you regarding this project You could see example of my work here : [login to view URL] (Those are presentations for my other clients but should give you perspective what can i do.) Hope to hear from you. Best Regards Łukasz Ożóg
$250 USD in 3 days
5.0 (7 reviews)
3.5
3.5
4 freelancers are bidding on average $535 USD for this job
User Avatar
A proposal has not yet been provided
$315 USD in 3 days
5.0 (6 reviews)
5.2
5.2
User Avatar
Hi, I am good at MS access vba. Looking forward to work on this project. I would like to discuss in the private chat.
$500 USD in 2 days
5.0 (33 reviews)
4.1
4.1
User Avatar
Hi, We are experienced programmer with more than 4 years of development experience here. We have handled production applications with various technologies like .NET, PHP (Codeigniter / Wordpress / Core Php), Classic ASP and many more using databases like MySQL, Microsoft SQL, Oracle, MS Access and etc. We are also developing mobile apps in Native technologies for iOS, Android and Windows platform. Mentioned below are a few USPs for choosing me: 1. Well written codes with proper documentation 2. Highest possible code optimization 3. Quick support through email / skype / telephone 4. Daily / Weekly status reporting Let's discuss and make this project a success. Thanks & Regards, JayamSoft
$555 USD in 2 days
5.0 (3 reviews)
3.6
3.6
User Avatar
I will help quickly and efficiently. The first result within 24 hours! Ready to do this job. So far I have only some closed projects in Access. Maybe your project will be the next? From the Access, of course, familiar.
$250 USD in 3 days
4.9 (8 reviews)
2.6
2.6
User Avatar
I know why it works only with correctly when a comma ( , ) . You need to define mapping file with columns while importing text files.
$833 USD in 10 days
5.0 (1 review)
2.1
2.1

About the client

Flag of IRELAND
Waterford, Ireland
5.0
5
Payment method verified
Member since Apr 24, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.