convert foxpro 3.0 table

Hi,

I've got about 6000 tables in foxpro 3.0 and a database in sql srv 2000.

now i've to convert the data of these 6000 tables into the database. the problem is that i have to convert all the tables seperatly!

is there a tool where i can convert these tables automatically?

i know it can with DTS, but the 6000 tables are divided over 1400 directories. So with DTS i can't convert them automatically.

does anyone know a solution?I dont see why not. Setup a string of load thru a query that loops. Try a complete import. I'm sure it can be done. You might want to test the process and do the conversion during off hours when there no other system activity.

Not a sermen

Just a thought|||I dont see why not. Setup a string of load thru a query that loops. Try a complete import. I'm sure it can be done. You might want to test the process and do the conversion during off hours when there no other system activity.

Not a sermen

Just a thought

so you are saying that i can loop through the directories with a DTS package?|||Yes, That's correct.
It may take some time to put together so doing manually depend on whether this process will need to be run multiple times??