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

en voir plus : sorted data set, sets in data structure, data structure set, basic of data structure, ms access trap validation text errors, transcribe sound files text, access nas200 files directly, convert files microsof publisher microsof work 2007, nas200 linux access web files, type picture files text money, perl search files text, transcribe audio files text, create html files text files, audio files text

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

Nº du projet : #8495023

Décerné à:


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

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% USD en 3 jours
(7 Commentaires)

4 freelance font une offre moyenne de $535 pour ce travail


A proposal has not yet been provided

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(6 Commentaires)

Hi, I am good at MS access vba. Looking forward to work on this project. I would like to discuss in the private chat.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(33 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 2 jours
(3 Commentaires)

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

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 3 jours
(8 Commentaires)

I know why it works only with correctly when a comma ( , ) . You need to define mapping file with columns while importing text files.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% USD en 10 jours
(1 Évaluation)