I am looking at approaches to getting data from files (eg., xls, csv) that are uploaded by external users of a data driven site, imported into a SQL database, and then displayed to public. I am looking at the FileSystemObject as an approach to read the data out and then move to SQL with basic SQL statements. This seems kind of bulky, and I was wondering if there is a more efficient way to go about the process. Happy to provide more detail info if it is unclear. Have used Tek-tips before to find very useful info...this is the first time to post a question.
Thanks in advance.
Thanks in advance.