Thread: code using Excel?

  1. #1
    Registered User
    Join Date
    May 2002

    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!

  2. #2
    End Of Line Hammer's Avatar
    Join Date
    Apr 2002

    Re: code using Excel?

    >>can I use excel to store the data?
    I'm not banking with you if you keep my personal data in Excel ! Yes you could use it, but how are you getting the data into XLS format? I presume you're going to stick with a CSV format (comma seperated data)?

    >>it's not picking up the pin field.
    Meaning what exactly?

    Suggestion: Using a CSV file you can open it in Excel easily and it'll format OK into cells. This structure of data is also relatively easy to load into a C++ program.
    When all else fails, read the instructions.
    If you're posting code, use code tags: [code] /* insert code here */ [/code]

  3. #3
    Registered User
    Join Date
    Aug 2002
    >>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:


    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.

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. Extended ASCII Characters in an RTF Control
    By JustMax in forum C Programming
    Replies: 18
    Last Post: 04-03-2009, 08:20 PM
  2. Enforcing Machine Code Restrictions?
    By SMurf in forum Tech Board
    Replies: 21
    Last Post: 03-30-2009, 07:34 AM
  3. Values changing without reason?
    By subtled in forum C Programming
    Replies: 2
    Last Post: 04-19-2007, 10:20 AM
  4. Interface Question
    By smog890 in forum C Programming
    Replies: 11
    Last Post: 06-03-2002, 05:06 PM
  5. Replies: 0
    Last Post: 02-21-2002, 06:05 PM