I am a novice to PHP and MYSQL, I have been asked to create a new database on MYSQL, I have problem with the data, right now I am in the process of understanding the data, but the data is in text format and I guess separated by spaces, it is not comma delimited and each record is divided into 4 lines. So how should my approach be towards creating the database and the reading the data? And do I have to write any script to read the data line by line and extract what I want and if so could any experts help me out with this. 010281C 64870002722101 BAY COMMUNITY BANK RM BAY NN0215 0078 2001022615:08 020126C 64870002722101 341741 757 5990895 PV 030367C 64870002722101 ATTN; MARKETING DEPARTMENT PO BOX 940 RUTHER GLEN VA22546 P 040109C 64870002722101 507082BAY COMMUNITY BANK 990237 I 6487001 1 0.0002 1 0.0003 1 0.0004 1 0.00 I have even added an example attachment on how it looks in a text file. Thank you all.