Can anyone tell me the best type of connection to allow Excel Files to be used as a datasource. I set everything up as a DSN-Less connection, and I have having problems with the Input Mode of my excel data. It seems to not understand IMEX=1;. Most of my activeX control is written, but I need the latest connection type to Excel.
Client will place data in an Excel Spreadsheet and place files in a folder on Server Machine
Server Machine does not have Excel Installed on it.
Server Machine will create a connection (however?), read the data and place it into an Access Database (Also not resident on the Server PC). Connection made Using ActiveX Data Objects 2.8
Would like my connection to be most scaleable, easist to use, and repeatable.