It'll not work for VFP7 and later VFP tables because it uses VFP ODBC driver.

>
>Sorry to point the obvious, but, do they have the file stored on their 'C:\SPCTesterSrc\SFH\ALS_Tension_Data' folder.
>
>Anyway, the following statement always worked for me.
>
>

>SELECT * FROM 
>Openrowset(
>	'MSDASQL',
>	'DSN=Visual FoxPro Database;SourceDB=c:\MyFolder ;SourceType=DBF',
>	'select * from MyDbfTable'
>	)
>

>