You could export the excel file in the csv format. Use the FileSystemObject to open the csv file as a text stream. Than use something like:<BR><BR> Dim objFSO, objFile, arrayValues<BR> Set objFSO = CreateObject("Scripting.FileSystemObject")<BR> Set objFile = objFSO.OpenTextFile("e:inetpubwwwrootexample.csv", 1)<BR> Do Until objFile.AtEndOfStream<BR> arrayValues = Split(objFile.ReadLine, ",")<BR> Response.Write(arrayValues(0))<BR> Response.Write(arrayValues(1))<BR> Response.Write(arrayValues(n))<BR> Loop<BR> objFile.Close<BR><BR>As you loop through each line of the Text Stream. arrayValues then holds a one dimensional array of the current lines values.
There was a thread that started back last August or so and kept getting postings for months afterwards where we beat this subject to death.<BR><BR>If you look for the combination of "excel" and a message written by me sometime back then, you should find the thread. Read all or at least most of the messages! I showed a way to do it *if* your spreadsheet was of the form "first row has column names, all other rows have data", but others found ways to read just pieces of a sheet.<BR><BR>It's all done via the Excel ODBC driver. You don't need a DSN, even.<BR><BR>
http://www.aspmessageboard.com/forum/showMessage.asp?M=45948&F=31&P=1<BR><BR>It was in the moderated advanced forum. Above is a pointer to my code that worked. But do read the follow on messages; there are some other good hints in there!<BR><BR>