Solved error on auto refresh linked tables with VBA code (1 Viewer)


Lifelong Learner
Local time
Yesterday, 19:19
Mar 14, 2017
I try to make the same with the same file in old version ofcDB:

Print DBEngine(0)(0).TableDefs("Fatture_Scadute").Connect
Text;DSN=Fatture_Scadute - specifica di collegamento;FMT=Delimited;HDR=NO;IMEX=2;CharacterSet=850;ACCDB=YES;DATABASE=C:\Nuovo QC_DT\Input


tdf.Connect = "Text;DSN=Fatture_Scadute - specifica di collegamento;FMT=Delimited;HDR=NO;IMEX=2;CharacterSet=850;ACCDB=YES;DATABASE=" & percorso & "\input"

it works!!!

So the problem was the filename in path, that work for .xlsx, I suppose, for the name of sheet....nice!

Thanks you all for help :)
Very glad to hear you got it working. And if it gives you too much trouble again, you have the other solution too--IMO the transfertext is much smoother than fuzting with connect strings. But glad it's solved!

Users who are viewing this thread

Top Bottom