Hello All! New here. Easiest way to import data?

[ZPaul2Fresh8]

Hello to everyone, I just purchased the enterprise edition after playing with the trial for a few days. I got to say I'm loving it, takes me back when I used to dabble in VB.

I'm not very experienced so my first project was a simple Blackjack Odds calculator. You simply input your 2 cards and the dealer's one card and it will prompt you on whether you should Hit, Stand, Split or Double Down. Anyhow moving on...

I've got it about done, the last thing I need to do is import data. It's basically in a table format which could be done in a spreadsheet.

Does anyone have any input or suggestions? Possibly examples to learn from? Thanks.

 

[Erel]

There are several possible methods:
- Save the data as a CSV file and load it with StringUtils.LoadCSV.
- Use jExcel library to open the MS Excel file (not really needed in this case).
- Convert the data to a SQLite database and open it with SQL library.

 

[ZPaul2Fresh8]

Thanks Erel. From the looks of things around here you ARE the man. :sign0060:

I will enable that Lib and try it out. Thanks again.

P.S. Thanks in advance because I'm sure this won't be the last time you help me out