Are you facing any problem ?
YES I NOT ABLE TO USE EXCEL 5.0
EARLIER WIT EXCEL 97-03 THIS WORKED BUT NOW ITS NOT
'selecting a particular acess field added to acess from excel
Set dbase = OpenDatabase(excelfile, True, True, "excel 5.0")
sqlquery = "SELECT * INTO [;pwd=nflsl;database=" & acessfile & "]." & acesstable & " FROM [" & worksheet & "$]"
' dbase.Execute sqlquery