>>>>>>I've managed to download SQL Server Express 2008 - what do I need to do in order to
>>>>>>
>>>>>>1. Open an .mdf file
>>>>>>
>>>>>
>>>>>Try attaching it. Right click on the Database/Attach menu
>>>>>
>>>>>
>>>>>>2. Be able to see this file in VFP 9
>>>>>>
>>>>>>Thanks
>>>>>>
>>>>>>Colin
>>>>>
>>>>>One of the ways would be to create a CursorAdapter class and use connection to your SQL Server table(s). Another way would be to simply use SQLExec() function.
>>>>
>>>>Thanks for the quick answer
>>>>
>>>>You said try attaching it. Right click on the Database/Attach menu - what app am I in to do this - I downloaded SQL server express but I can't start it up
>>>>
>>>>Your 2nd answer I'll check out in detail
>>>
>>>http://www.quackit.com/sql_server/tutorial/
>>>http://www.learnvisualstudio.net/content/videos/Lesson_9_Using_SQL_Server_Management_Studio.aspx
>>>http://www.learnvisualstudio.net/content/series/getting_started_with_sql_server_2005_express_edition.aspx
>>>http://www.tizag.com/sqlTutorial/
>>>
>>>http://www.devarticles.com/c/a/SQL-Server/How-to-Connect-to-a-SQL-Server-from-Visual-FoxPro/
>
>Thanks a lot for that

There are probably hundreds of posts here on how to connect to sqlserver from foxpro and post resolving problems with it. However, if you've never worked with sqlserver before, sometimes it's good just to walk the steps of a tutorial first. (IMHO) That usually works best for me :o) Hope some of the links help,,,