>>>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
You might need :
#DEFINE acQuery 1
instead of acTable and replacing "Employee" to "select * from employee" style.
Cetin