Importing data into SQL Express

[Guest]

Hi (hope this is in the right forum)
We have an app that was done in FoxBase 2.6. We need to pull the data into
SQL Express. We have some data in the new app now via mapping DBF's to an
Access 2003 MDB then up sizing. Since we upsized the MDB we have made
structure changes to the MDF.
I would like to go directly from the DBF's to the MDF and just map the
fields from one to the otherif I can. I read about importing into SQL but
the number and syntax of the explanations left me with the impression "it can
be done, but which scenario to use?".
Has anyone done this? What is the best plan to do it?
DBF to MDF or
DBF to CVS to MDF
or what?
Thanks

 

[Jonathan Roberts]

Hi (hope this is in the right forum)
We have an app that was done in FoxBase 2.6. We need to pull the data into
SQL Express. We have some data in the new app now via mapping DBF's to an
Access 2003 MDB then up sizing. Since we upsized the MDB we have made
structure changes to the MDF.
I would like to go directly from the DBF's to the MDF and just map the
fields from one to the otherif I can. I read about importing into SQL but
the number and syntax of the explanations left me with the impression "it can
be done, but which scenario to use?".
Has anyone done this? What is the best plan to do it?
DBF to MDF or
DBF to CVS to MDF
or what?
Thanks

If it were me, I would go to CSV first.

 

[Guest]

Thanks Jonathan, are there any reasons for that opinion?

 

[Jonathan Roberts]

Thanks Jonathan, are there any reasons for that opinion?

No, just habit