HOW DO I LINK MS ACESS 2000 WITH EXCEL-2007 ,,EARLIER I HAV LINKED MS ACESS 200 WITH EXCEL-2000 USING CONTROL "Excel 5.0" ,,what do i do for excel -2007
-
-
Are you facing any problem ? -
YES I NOT ABLE TO USE EXCEL 5.0Originally posted by debasisdas
EARLIER WIT EXCEL 97-03 THIS WORKED BUT NOW ITS NOT
'selecting a particular acess field added to acess from excel
Set dbase = OpenDatabase(ex celfile, True, True, "excel 5.0")
sqlquery = "SELECT * INTO [;pwd=nflsl;data base=" & acessfile & "]." & acesstable & " FROM [" & worksheet & "$]"
' dbase.Execute sqlqueryComment
Comment