Re: Creating ODBC socket connection to Excel

["-==cfSearching==-" <webforumsuser@xxxxxxxxxxxxxx>]

[q]They are accustomed to Excel, and would like to bulk-upload data from Excel 
to the program (which is based in MS SQL). I've simplified the Excel file so as 
not to confuse the users, and will need to process each record before I can 
push it to the database (error checking, cross-referencing the sheets, etc). 
This prevents me from using ye olde MS SQL import functionality.[/q]

 Specificially what prevents this? Information could be imported into a 
temporary table, then validated and imported into your main tables.