Foxpro tables to SQL Server

[voidmain]

hi,

I want to programmatically import data from a .dbf file to sql server 2000 and I would like to automate this process, rather than using another piece of s/w.

I want this importing to happen on a time basis (every half an hour, it imports, for example). What procedure do i have to follow and how do i go about doing it.

Thanks a lot.

voidmain

[Shuja Ali]

Microsoft Data Transformation Services (DTS) is the one you should be using. You can set a Job in SQL Server that will can call a DTS Package which inturn will import data from your DBF file to the SQL Server.

You should take a look at following in Books Online (SQL Server)
DTS
Scheduling Jobs.

[voidmain]

Shuja,

Thanka a lot for that info. it really helped.