asked on

Importing Text File

Hi
I want to import an unstructured text file to MS Access, the file look like this

Name> DICK E. ORENSE Number> 11358
10/28/00>
--> 11:40 - 19:22
Daily Total: Regular- 07:42 Overtime- 00:00 Docktime- 00:00
10/29/00>
--> 11:42 - 18:53
Daily Total: Regular- 07:11 Overtime- 00:00 Docktime- 00:00
10/30/00>
--> 11:33 - 18:59
Daily Total: Regular- 07:26 Overtime- 00:00 Docktime- 00:00
10/31/00>
--> 11:42 - 19:12
Daily Total: Regular- 07:30 Overtime- 00:00 Docktime- 00:00
11/01/00>
--> 11:38 - 18:56
Daily Total: Regular- 07:18 Overtime- 00:00 Docktime- 00:00
11/02/00>
--> 07:37 - 14:32
Daily Total: Regular- 06:55 Overtime- 00:00 Docktime- 00:00
11/03/00>
Time array empty
Daily Total: Regular- 00:00 Overtime- 00:00 Docktime- 00:00
Final Total: Regular- 40:00 Overtime- 04:0211/03/00 Docktime- 00:0011/03/00

Name> DR. SOHEIR ELSABAE Number> 11350
10/28/00>
Time array empty
Daily Total: Regular- 00:00 Overtime- 00:00 Docktime- 00:00
10/29/00>
Time array empty
Daily Total: Regular- 00:00 Overtime- 00:00 Docktime- 00:00
10/30/00>
Time array empty
Daily Total: Regular- 00:00 Overtime- 00:00 Docktime- 00:00
10/31/00>
Time array empty
Daily Total: Regular- 00:00 Overtime- 00:00 Docktime- 00:00
11/01/00>
Time array empty
Daily Total: Regular- 00:00 Overtime- 00:00 Docktime- 00:00
11/02/00>
Time array empty
Daily Total: Regular- 00:00 Overtime- 00:00 Docktime- 00:00
11/03/00>
Time array empty
Daily Total: Regular- 00:00 Overtime- 00:00 Docktime- 00:00
Final Total: Regular- 00:00 Overtime- 00:0011/03/00 Docktime- 00:0011/03/00

There is employee name, employee id, date, time in, time out and some messages
thanx

jjafferr

Hi humaid,

for 50 points, Please see
https://www.experts-exchange.com/questions/20979832/Import-word-file-into-table.html

Hope this helps

Jaffer

jjafferr

humaid,

and
https://www.experts-exchange.com/questions/20940488/Parse-emails-from-Outlook-Express.html

just take the part that pertain to your question

humaid

ASKER

Dear jjafferr
Can you help me please, this is very impotant to me
i have updated the points to 500 points
thanx

jjafferr

I am sorry humaid, it was just a line of joke, I didn't mean to ask you to change the points, I just thought you will be able to walk through the answer and solve your question,
OK, I will work on it and reply back.

Where are you from, if you don't mind me asking, I am from Oman.

jaffer

humaid

ASKER

Thanx alot, i am from the UAE.

jjafferr

pls call me on 050-6688632

jaffer

jjafferr

Let me understand this a bit more,

Name:DICK E. ORENSE
Number:11358
employee id: 10/28/00>
time in: 11:40
time out: 19:22
message: Daily Total: Regular- 07:42 Overtime- 00:00 Docktime- 00:00
10/29/00>
--> 11:42 - 18:53
Daily Total: Regular- 07:11 Overtime- 00:00 Docktime- 00:00
10/30/00>
--> 11:33 - 18:59
Daily Total: Regular- 07:26 Overtime- 00:00 Docktime- 00:00
10/31/00>
--> 11:42 - 19:12
Daily Total: Regular- 07:30 Overtime- 00:00 Docktime- 00:00
11/01/00>
--> 11:38 - 18:56
Daily Total: Regular- 07:18 Overtime- 00:00 Docktime- 00:00
11/02/00>
--> 07:37 - 14:32
Daily Total: Regular- 06:55 Overtime- 00:00 Docktime- 00:00
11/03/00>
Time array empty
Daily Total: Regular- 00:00 Overtime- 00:00 Docktime- 00:00
Final Total: Regular- 40:00 Overtime- 04:0211/03/00 Docktime- 00:0011/03/00

In other words, you don't care about message details, right?
you only want to dump this to a field.

jaffer

ps: I live in Abu Dhabi

humaid

ASKER

Jaffer
Yes, but 10/28/00 is date not employee id, is it possible to store the messages for each date.
another thing is sometimes we have multiple in and out for example

Name> DICK E. ORENSE Number> 11358
10/28/00>
--> 11:40 - 19:22
--> 22:00 - 23:30

regards

jjafferr

How many maximum multiple in and out?
Two like in your example?

jaffer

humaid

ASKER

up to 6, can you set it as a changeable variable
regards

ASKER CERTIFIED SOLUTION

jjafferr

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

humaid

ASKER

Thanx alot brother
it is really helpful, thanx for your efforts
regards
Ahmed

jjafferr

Hey I am glad I was of help,
thanks for the points and the grade.
lets do this more often ;o)

jaffer