I put together a complete working example of how to read a CSV file. It also includes a class to read and write an old Windows style INI configuration file.
Here is the link to download a ZIP file with the Xojo program and an example INI file.
I saved the program in Xojo Project format AND Xojo Binary format. I think the Binary format only works if you have a paid version of Xojo.
Things to watch out for:
1) I tested this on a MacBook (OSX) but I think you are using Windows. This should work fine but there might be some "quirks".
2) Make sure the Copy File setting in the Build Settings in the IDE works. Those are found on the left column in the IDE and the Build Settings are on the bottom of that column. These copy a file (the sample INI file in this case) to where the executable file exists when it runs. You could put the INI file in some other directory and "hard code" where it was located. The code to read the INI file is in the APP.OPEN event and it currently assumes the INI file to be in the same directory as the executable. These don't do anything useful for this example but I figured you might need them later. You can also examine them to help understand file reading/writing.
3) IMPORTANT - Find the System.DebugLog viewer on the bottom of the IDE. It is the little icon on the bottom of the IDE Window that looks like a WiFi symbol leaning to the right. There is code you will see in the program that displays stuff for debugging. VERY HANDY, especially when trying to learn something and see how it works.
4) This example lets you pick the desired CSV file from a popup dialog and defaults to looking for CSV files.
5) It assumes that your sample CSV file starts with the column names in row one. When you open the CSV file it loads the column names into an array. There is also another array you may not need but I used it to determine if the column was a string or a number. I loaded it from another source and that code is NOT in this sample program.
6) Once the CSV file is opened another button becomes active to load the data. It does not actually load anything but it does loop through the records and checks that the number of columns in the data rows match the number of columns in first row of names. When done it will display the record count or an error message if that happens.
7) I do some special processing of the delimiters in the CSV file with a convert function (NormalizeDelimiters) I wrote. I assume commas in input but that could be changed. I then convert each row when read to change the delimiter to an ASCII Chr(0). I observe quoted ("xxx") fields and keep the comma delimiters inside of pairs of quotes but I remove the quotes on the row that is returned by the convert function. This avoids the whole problem of commas and quotes in data fields.
8) Take a look at the Array Append function. Look up Array in help (click the ? in the top of the Xojo IDE). Scroll to the bottom and click APPEND under the heading "See Also". I don't think Liberty BASIC has any equivalent and I have found it pretty handy in Xojo. It lets you add new elements to the end of an array without having to pre DIM the total size but I don't think it works for multi-dimensional arrays.
Please dissect this program to understand it and don't just use it and ignore how things are done. Read the WHOLE THING including the comments before you try any modifications.
I am a subscriber to xDev Magazine (Marc Zeedar's post above) and the beginner article looks pretty useful. It has lots of info about the IDE in addition to the Xojo language itself. It would save you WAY over $10 in aspirin for headaches.
Eventually you will probably want to learn about SQLite for databases but for now see if you can take this skeleton and add some code to actually deal with the CSV file and do something useful. Remember you can put in lots of System.DebugLog statements to output messages and take "baby steps" to test your code. Make a few changes, print some stuff with System.DebugLog, and then repeat.
If you need more general help post here. If you have trouble with this example program also post here and I will try to help.