En cours

Importing text files to MS Access

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:

[url removed, login to view]

Compétences : Microsoft Access, Visual Basic

Voir plus : sorted data set, sets data structure, data structure set, basic data structure, transcribe sound files text, access nas200 files directly, perl search files text, transcribe audio files text, audio files text

Concernant l'employeur :
( 5 commentaires ) Waterford, Ireland

N° du projet : #8495023

Décerné à :

lukaszoz

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 Plus

250 $ USD en 3 jours
(7 Commentaires)
3.5

4 freelance ont fait une offre moyenne de 535 $ pour ce travail

programer218

A proposal has not yet been provided

315 $ USD en 3 jours
(6 Commentaires)
5.2
cgullapalli

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 en 2 jours
(33 Commentaires)
4.1
jayamsoft

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 Plus

555 $ USD en 2 jours
(3 Commentaires)
3.6
aleator

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, famili Plus

250 $ USD en 3 jours
(8 Commentaires)
2.6
pnjadhav

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 en 10 jours
(1 Commentaire)
2.1