How to transfer or export dbf file to SQL server 2005 express edition?

I need to transfer dbf file to sql server 2005 express edition with some periodic interval. Can any one please recommend which is the easiest and efficient method to do?. Like polling every 5 to 10 seconds transfer data to sql server 2005 ex edition.

Is it recommend to do it visual basic program?, how to do it. pls help

Hi Stephen,

In SQL 2005 you can set up a linked server, a stored procedure, and a recurring job to run the stored procedure. I'm assuming you want to import only new or changed rows from the DBF and the stored procedure would allow you to do this before you update your main table.

I don't usually work with SQL Express, and I see that you can set up a linked server, but SQL Server Agent is not available to set up the recurring job. However, you could write an external program (such as in VB) to call the stored procedure at the desired intervals.

how to transfer data from dBase to SQL?

I have some database files with .dbf from dBase and I want to transfer data from the .dbf files to Microsoft SQL database (2000). Can someone help me with that? Thanks.You can use Other ODBC Data Source and select dBASE Files.|||rdjabarov, can you give me more details for that? Thanks.|||When I did the way you told me, I got the following error message:

Error Source: Microsoft OLE DB Provider for ODBC Drivers

rror Description: [Microsoft][ODBC dBase Driver] The Microsoft Jet database engine could not find the object 'users'. Make sure the object exisits and thet you spell its name and the path name correctly.

Context: Error calling GetColumnInfo. Your provider does not support all the interfaces/method required by DTS

What should I do with that error message? Thanks.|||I am not surewhy you got the error. You need to confirm that the version of dBASE that was used to create tables is supported by the ODBC Driver for dBASE. Another way to do it would be to open an Access database, import dBASE tables into it, and then use DTS to import tables from Access db.