Hi<BR><BR>I&#039;m tying to get a list of worksheets from excel through a .xls DSN and using the following code. (Meant for an Access DB).<BR><BR><BR>dsn=("exceltest")<BR> Function ConnectADOLEB( ConnectionObject ) <BR> Set ConnectionObject = Server.CreateObject("ADODB.Connection") <BR> <BR> ConnectionObject.Open(dsn) <BR>End Function <BR>Const adSchemaTables = 20 <BR>ConnectADOLEB oConn <BR>Set rs_Stores = oConn.OpenSchema(adSchemaTables) <BR><BR><BR>After outputing the recordsed, I keep getting $ signs around all the worksheets but one e.g.<BR><BR>worksheet1$ SYSTEM TABLE<BR>worksheet2$ SYSTEM TABLE<BR>worksheet3$ SYSTEM TABLE<BR>worksheet1 TABLE<BR><BR>What does this mean and why does just one worksheet have "TABLE" as the type of table/worksheet?<BR><BR>Any help on this would be great!<BR><BR>Sarah<BR><BR><BR>