Database Software

Dear all,

I need to create a temporary table getting data from a text file. I am very new to data loading could you please help me how to read the text file in to a temporary table.

i have text file like as below:

order items : books Purchasing

start date:
8-11-09
Notes: Books are selling from aug10 to aug 25
Action performed
Time
Verified By

sold out from shop, sold out date:_________

1.
physics _______ book sold to ravi
_______
_________

2.
social _______ book this is a good book
sold to kiran
aug10th
ronald

3.
maths book to sal
_____
__________
4.
english book__________ this was a newbook
to raj
__________
jak
return to shop, return date:____________

1.
maths book return by:_____________ Verify book
aug11th
john

2.
story book by:_________ checked
aug14th
_________

Now i need to create a temporary table and insert the data into the table from this text file.

Now i need to create a temporary table named as books_order with 5columns(order,Status,Action_Performed,Time,Verified_By) like as below:

Order status Action_Performed Time Verified_By

books Purchasing sold physics _______ book sold to ravi _______ _________
books Purchasing sold social _______ book this is a good book sold to kiran aug10th ronald
books Purchasing sold maths book to sal _____ __________
books Purchasing sold english book__________ this was a newbook to raj __________ jak
books Purchasing return maths book return by:_____________ Verify book aug11th john
books Purchasing return story book by:_________ checked aug14th _________

Thanks in advance.