SQL Server has a wizard that will move an Access database into SQL Server. I'm not sure if it creates all the constraints and keys - but it definately will move all the tables into SQL Server.
>I was hoping that VFP would have an easy wizard to convert Access data to VFP but alas, no such thing.
>
>What would be the easiest way to convert data from Access to VFP? I have never used Access so have no idea what is inside a .MDB file. Can I "get" inside Access from VFP (without knowing the structure of .MDB)? Would SQL Server make the job easier?
>
>Any suggestions would be greatly appreciated.
Al Williams
Anola MB, CANADA