Ach, VFP ... what a pain. Still have a lot in our shop, but hoping to kill most of it this year ;)
Not sure if you can actually use SQL Server as the intermediary, like you do with Access, but you can definitely create SSIS scripts to pull VFP data into SQL tables, which is what we do for a few widely used tables. > I am working on a project that connects to an ERP system running > Visual Fox Pro as its backend. > > Ideally I would like to connect SQL Server to the VFP database and use > SQL Server as the interface, like you can with Access. Does anyone > know if that's possible? Good idea or suicidal? > > Thanks, > Duane ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340789 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
