OK,

That's very very cool
More info is required from me I guess.

I created a COM Based ('Query Runner') descriptive LAME NAME I know but what it does is it take the parts of a SQL Statement and Macro Subsitutes it and brings back data to a Server Based Temp File that the user has a reference (NAME) to.

Effectively it run's a query generated on a client at the server and drops a temp file in a user visible directory...

NO UDPATES, DELETES, or any data manipultion is required at all just (GIMME the data) I control how long the temp files live and such so this might be very posssible

I'll keep bothering you

thanks


jp


>>I guess I could move the small DBC files into SQL-Server but I'm not giving up hope yet....
>>
>>
>>My point is that I want to SLOWLY move to SQL-Server over at least 2 or more progam upgrades (mine not MS's) not in one fell swoop (sp..)
>>
>>jp
>
>If all you want is to Query you could be able to create a Linked Server in SQL to Foxpro. But the MS site states
>
>Note When you use Visual FoxPro OLE DB Provider as a SQL Server-linked server, only queries are supported. The Visual FoxPro OLE DB Provider does not support update, insert, or delete operations through a linked server