F
Farmer O
I've upgraded from access 2000 to 2008. Last year I cobbled together some
code that looped through numerous sheets in a number of excel workbooks and
entered thi information in the appropiate table in an access database. In
access 2000 it worked fine however in 2008 error 3051 is generated.
.ConnectionString = "provider=microsoft.jet.oledb" & _
".4.0;data source=" & strwbknm & ";extended " & _
"properties=""excel 8.0;hdr=yes"""
.CursorLocation = 3
.Open
End With
CODE TO IDENTIFY WHOSE SPREADSHEET
On Error GoTo errhndl
'transfer
spreadsheet into db
DoCmd.TransferSpreadsheet acImport, 8, _
impta, strwbknm, True, strsheetname
Is error 3051 generated because the same path is in the trasfer and
connecting string code. If is there a simple way around it.
thanks
code that looped through numerous sheets in a number of excel workbooks and
entered thi information in the appropiate table in an access database. In
access 2000 it worked fine however in 2008 error 3051 is generated.
.ConnectionString = "provider=microsoft.jet.oledb" & _
".4.0;data source=" & strwbknm & ";extended " & _
"properties=""excel 8.0;hdr=yes"""
.CursorLocation = 3
.Open
End With
CODE TO IDENTIFY WHOSE SPREADSHEET
On Error GoTo errhndl
'transfer
spreadsheet into db
DoCmd.TransferSpreadsheet acImport, 8, _
impta, strwbknm, True, strsheetname
Is error 3051 generated because the same path is in the trasfer and
connecting string code. If is there a simple way around it.
thanks