Solved error on auto refresh linked tables with VBA code (2 Viewers)

Isaac

Lifelong Learner
Local time
Today, 00:53
Joined
Mar 14, 2017
Messages
8,738
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

With

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