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 |
|
ssrikrish
Yak Posting Veteran
69 Posts |
 Posted - 2005-12-12 : 20:05:42
|
| Team,I have to convert foxpro tables(dbf files) into sql server. what is the easiest way to do it? Let me explain the situation. The client does not know the valid files to import and I have no way of identifying the pertinent data to convert without importing them into some staging tables so that i can take a look at the data. They are converting from their legacy system into ours. I know that i don't need all the dbf files. I know the following available options:1. use DTS package. create a DSN for each dbf file and import. There are 100's of dbf files and this would take forever.2. use Access. Same thing. Need to create a odbc datasource for each file.3. import the entire foxpro database and query each and every table to identify valid data. The foxpro db is extremely big (50 + GB). Hence the time for data transfer is a consideration.It seems like all the 3 options are time consuming. Pls let me know if there is a short cut to handle this.Is there a way to generate csv/tab-delimited txt/xls files from foxpro? This would be the simplest if there is a way to do it. I am not well versed with foxpro and if you know the foxpro commands to do it, that would help me a lot. I can then import them into sql server easily.Appreciate your help.Thanks,Sri |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2005-12-12 : 20:50:54
|
| Duplicate [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=59006[/url]-----------------[KH] |
 |
|
|
|
|
|
foxpro to sql server conversion