>>Cetin, Almost got this working too except on the last line, it comes up with the fatal error OLE Dispatch Exception code 0 from MS Access (ODBC call failed). I assume I could modify this to work with free tables rather than DBC? I'll check the documentation on all this new stuff. Exciting. Thanks a lot. Or is it Tesekkurler or even Çok tesekkur ederim?
>
>Hey don't tell me it's altavista translation. Perfect Turkish :)
>Off the top off my head for free tables :
>Visual Foxpro Database would be 'Visual Foxpro Tables'
>SourceType=DBF
>SourceDBC && Remove
>DBQ=FreetablesFullpath
>If that doesn't work inform and I'd find a syntax (somewhere here).
>Cetin
Found one :
"DSN=Visual FoxPro Tables;SourceDB="+lcFPDataFullPath+";SourceType=DBF"
Cetin