Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
edb2003
Yak Posting Veteran
66 Posts |
 Posted - 2003-12-09 : 01:06:00
|
| Hi Everyone, I was trying to import existing foxpro .dbf format files into SQL Server 2000 but was unable to. Does anyone know how to do this and what steps I need to take to do it.I appreciate your help :)Edb |
|
|
scootermcfly
Yak Posting Veteran
66 Posts |
Posted - 2003-12-09 : 07:48:38
|
| When I import FoxPro into SQL 2000, I typically create a File DSN and use that to point to using DTS.For the DSN, you should be able to set that up in the ODBC manager and point to a Free Table directory.Make sure that if there are any dates in your FoxPro table, that you change the data type to datetime, the DTS wizard usually likes to leave at smalldatetime and this gives me some problems.You can also use the FoxPro upsize database Wizard and point to your SQL database, this works pretty good but can be a little slower than DTS.Let me know if you have any problems, or need anything,Scooter McFly |
 |
|
|
edb2003
Yak Posting Veteran
66 Posts |
Posted - 2003-12-09 : 10:54:42
|
| Thanks Scooter, This information helps, however, there really isn't a way to export out of Fox Pro and import into SQL, right? ODBC appears to be the only way. I am curious of what kind of performance hit I will have when I use it with my .Net application I am building.All I wanted to do is view the data and implement it into prototypes for a client project for .Net.If ODBC is the way, do I make connection strings in .Net to go to SQL Server or ODBC?I am just curious. I thank everyone in this forum for there assistance.Happy Day and Happy Coding,edb |
|
|
|
|
|
|
|
|
Importing FoxPro .dbf files into SQL Server 2000