Hi!
Is the last part of this code (bold) necessary or recommended?
Apparently it works without it.
Thanks!
Is the last part of this code (bold) necessary or recommended?
Apparently it works without it.
Thanks!
VBA Code:
ado_Conex.Open "Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};" & _
"DSN=TESTSQL;DBQ=" & sPath & sFile & ";ReadOnly=0;DefaultDir=" & sPath _
[B]& ";DriveId=1046;FIL=Excel 12.0;MaxBufferSize=2048PageTimeOut=5;[/B]"
Last edited: