Table Filtering

[Saj]

I have a large excel spreadsheet containing place names with lat and lon values. I would like to filter on place names and display the filtered points. What would be the most efficient method of implementing this? Do I need a database?

 

[Erel]

Using a database is usually faster than adding everything to a Table control.
How large is your data set?

 

[Saj]

Hi Erel, the table will runs into 000's of rows. Which database do u suggest?

 

[Saj]

Looking through SQLite database engine material, I think this will be appropriate. One question, what database should I use, there's loads of them out there, MySQL, MS Access, IBM DB2...

 

[Erel]

If you want to have a local database then your only option is to use SQLite (which is a good option).