Hi again i found a script that ptrex made, it was originaly made to read an excel file as a database and counting all the records. what i did was query all the records however i can only get only one column record.
this one works.
Const $adOpenStatic = 3
Const $adLockOptimistic = 3
Const $adCmdText = 0x0001
Global $s_Filename=FileGetShortName("D:\My Documents\PROGRAMS\DataBase Update\8082009-042011.xls")
Global $s_Tablename = "[Sheet1$]"
; Initialize COM error handler
$oMyError = Ob