Thread: code using Excel?

I am writing an ATM program that will contain a database of customers - name, address, account no., balance. etc. I need to perform transactions - withdrawals, deposits, account balance, transfer, tx history. My question is - can I use excel to store the data? I did have a text file, and I have transferred data over and it opens the file ok, but when I enter pin to access an account, it's not picking up the pin field. Is there a way in the formatting to get myself over to the appropriate field, ie PIN?? I can't seem to find any examples anywhere. Thx!

>>it's not picking up the pin field.

I believe he is talking about the PIN field in his text file. If that is what you are talking about then you need to post the code that you use to get the infrmation from the text file.

Also how is the data in your text file formatted?

Do you have something like this:

Name;Address;Phone;Pin

where every line is an account number, and you have the fields delimited by something like a comma, semi-colon, or so on?

Because is that is the case I believe that you forgot to change the delimiter in your code to a "/n" for the last field (PIN), and that is why it is skipping it.