Transfer foxpro .dbf to SQL server

[Yu Chin Tsai]

I recently install SQL server on my computer. The problem I have now
is to transfer Foxpro table that I used to stored data into the
SQL server. I've tried copying foxpro .dbf file into different file
formats(including delimited with comma, delimited with tab, and
system data format), then using BCP with /r\n /t","(or /t\t) to
transfer data, BUT none of these works. Could someone give me any
opinion on this question. Thank you. - Lynn

[Boistuaud Frederic]

BCP certainly works, it is very fussy, and user unfriendly but extremely
quick.
I'm using bcp every day to import around 18,000 rows (39 fields per row)
and it takes about 10 seconds.

My advice, start simple, and keep it simple. I only use text and then
convert to money etc...
Start with one table with one column of text, if that works add more until
it does what you want.
--
Frédéric.

Yu Chin Tsai <yut...@newstand.syr.edu> wrote in article
<5eilt4$8...@newstand.syr.edu>...

[Dwight Muhlbeier]

Use Database Desktop...As long as you have aliases for the fox ODBC driver
& your
SQL Server database, it will work fine.

[PSCNY]

If you have FoxPro 5.0 then try using the "Upsizing Wizard". It's not as
fast as BCP but does the job.
Good Luck.