Complex text file into ms access

[adamdaban]

Ade, I don't know what I should do? Also, i need it, if you have any advice, please let me know

[NeoPa]

Adam.

It seems clear you don't have the necessary skills to handle a project like this at this stage. Earlier advice for you (See posts #7 & #8.) indicated you needed better understanding and that a tutorial or two might help. That is still an option, but frankly you communication skills fall too far short to allow you to benefit as much as others from this site. I suspect that's largely due to a language barrier, but it's also, at least partly, due to your failure to respond to all that's written for you. Questions put to you go without an answer. Possibly due to the fact you don't understand the question, but nevertheless a response of some kind is always required.

I suspect my most helpful advice at this stage is to get someone in with experience who can help. Someone that has the whole story that you've struggled to impart clearly here. Employers often misjudge the skill and experience levels required for such projects. It seems you've been dropped in to one that's a bit above your level. If you do manage to convince your boss to get someone in then they may well wish to start with the work that ADezii has already prepared for you. I suspect ADezii has now given up on trying to extract the meaningful information he needs in order to be able to continue to help you.

Best of luck.

PS. Please don't think I'm trying to be rude when I talk about your abilities. We all start somewhere and they are important considerations when trying to answer your question as where you can go next. This may be a learning experience for you - if you want it to be and you have the drive to make it so.

[adamdaban]

I don't understand why you are thinking like this way and judged me! This website for exchange idea and if you don't like I am there just talk with admin and withdraw me!

[Rabbit]

Adam, have you done a class or tutorial on Access VBA yet?

[NeoPa]

AdamDaban:
I don't understand why you are thinking like this way and judged me!

It's quite simple really. I'm not judging you or condemning you. You've asked me for advice and I feel bound to give the most helpful advice I can. Clearly I have to take into consideration whom it is that I'm giving advice to. If I were to give the same advice to you as I would to someone else who is experienced in Access then that would be inappropriate. You would have been unable to understand it or make any use of it.

Of course, I've used your comments and your responses to questions and other posts to allow me to respond in the most helpful manner I can. Bear in mind my comment was not offered out of the blue. It was posted only in response to your request. If it had been my intention to insult you then there was far more scope available (that I did not use). I used only what was needed in order to answer your question.

As with every piece of advice I offer, the person to whom it is directed, you in this case, is always perfectly at liberty to choose how much, if any, they follow that advice.

AdamDaban:
This website for exchange idea and if you don't like I am there just talk with admin and withdraw me!

Technically this site is for Developers and IT professionals. That said we have a large number of amateurs come to ask for help and technical advice. As a general rule you'll find we're happy to work with anyone who wishes to ask a question.

For the record, I am an admin. Not that I would ban you even if I did have a problem with you being here (which clearly I don't). We do ban members from time to time, quite rarely, but only when they continually break our rules (or spammers who go straight away). The worst that could be said about you is that you don't make it at all easy for people to help you. So, I have no problem with you or your presence here. Apart from some frustration trying to assist you, nor does anyone else.

Let me just say, in case it's relevant, that most of us here appreciate that people who generally use languages other than English have a much harder time trying to communicate their questions. We are an exclusively English Language forum. While we understand that, and make allowances where possible, we can only work with what we understand.

[adamdaban]

I trying to learn more I'm not so good at VBA

[adamdaban]

Thanks for every things

[Rabbit]

I trying to learn more I'm not so good at VBA

The first thing you'll want to start with is to learn the basics. Without it, you won't be able to implement any of the solutions we provide you with.

So start with a tutorial, something like this one: http://www.functionx.com/vbaccess/index.htm.

There is a list of lessons on the left, start with lesson 1 and work your way through them to get the basics. Normally, I would say you can stop at lesson 52. But for the purposes of your question, you should do all 65 because the ADO and XML lessons will be helpful in solving your original question.

Once you have a foundation, then you will be able to understand and implement the code that ADezii has provided.

[adamdaban]

amazing resource thanks

[NeoPa]

Hi Adam.

I understand that learning a new skill can be slow and laborious. I recommend trying out some tutorials before going for the more complicated stuff. Play with the tutorials and see if you feel this is something you can do, and would like to do. It's always hard to jump right in on a proper and difficult project.

Give yourself time to get up to speed. Enjoy the feeling of creating something and coming up with new ideas to make something happen the way you want it to. It can be real fun if you're suited to it.

Why not see what you can get from some of these tutorial links :

1. Microsoft Access Tutorials (Strive4Peace).
2. Microsoft Access Tutorials
3. Microsoft Office Tutorials.
4. VBA Tutorial (Excel).

They may not all suit you but I expect you'll find some of them very helpful.