Importing data into SQL Express

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
RichG said:
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
Click to expand...

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