Hey everybody,

Looks like I'm going to be busy over the holidays with some client work. Specifically I'm in the planning stages of a quiz game which has a potential database of nearly 10,000 questions.

The app is going to need to come with all the questions included, no loading from a web source will be possible. The client will be providing me with Excel files.

So my questions is, what format do you think I should store the data in? This is both a question for how I will read the data in the app, and also how I will convert the data from the supplied excel files into the format I need.

Thanks for any advice!

An SQLite database would definitely work. Open Excel and export to CSV. You can then suck that in and massage into the format you want.

Thanks Seth. I was thinking SQLite might be what I should be researching but didn't want to start if it was the wrong thing. So that clarification helps a lot - cheers!