>>

>>lcSourcefile = 'D:\DATA\Yourtable.ACCDB'
>>lnConnHandle = SQLSTRINGCONNECT("Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=" + lcSourceFile)
>>

>
>Tore,
>as always, you are the man
>Thanks
>I had in the meantime gone the hard way through export to excel and then in vfp import
>fortunately there are only 6 table involved
>
>Peter

As always, you're welcome!