A few million :sign0137:Well, I dont need a table actually. i want to store over a few million data in the CSV file to retrieve with a search function matching one or two entries.
You're going to have fun sorting out which hands are valid after you drew the first cards & the subsequent interactions that get you to 7 cards drawn per hand...I want to store a table containing numbers. The program computes the rank of a hand in poker with 7 cards, taken the best 5 out of it (Texas Holdem). Because there are 133784560 combinations with 7 cards out of 52, it takes too long to compute the hands, especially because I want to run simulations with dealing a lot of hands (Monte Carlo simulation) and compute the probability of winning with that certain hand against other random AI-hands.
Open one with Wordpad or Notepad. They are just normal text files.What is the general format/ routine to read in CSV files
If FileExist ("text.csv") = true Then FileOpen (c1,"text.csv",cRead ,, cASCII) r = FileRead (c1) Do Until r = EOF fields() = StrSplit(r,",") Msgbox(fields(0) & " - " & fields (1)) ' do whatever with the fields r = FileRead (c1) Loop FileClose (c1)