We let the genie out of the bottle and put it in our Alpha Five Version 10.5 feature pack of the week. The Import Genie feature pack lets you upload data from an Excel file or a comma delimited ASCII file from the end user's computer. It then imports that data into the current Grid or another external table.
Instead of manually entering information one row at a time, this feature pack enables you to load a large amount of data at once. You can also create a server-side event to do data validation. So after you've uploaded the file to the server, you can validate the data and then import it into the target table.
Watch the videos to see how easy it is to add this new feature pack, server-side data validation, and more.