MSSQL to DBF import/export

I'm fairly new to MS SQL Server, but I'm looking for someone to point me in the right direction with importing and exporting to a DBF file. Any ideas will be much appreciated.

I'm trying to create a site in asp/mssql that will replicate data held in local dbf files. Every so often, I need to synchronize the mssql db from the dbf files so the web site shows "live" data. This will mean both importing and exporting.

Thank you, in advance,

Andonis

what in specif would you like to know? There's many ways to do it, such as snapshots that do it once every x hours, or transactional which will update each time something occurs. The easiest way is just to open the DB in enterprise manager, and run through the wizards they have when you right click on the DB.

Unfortunately they can also be really finicky, which is why i tend to stick with DTS packages. My advice, look at what you need, then start messing around with it, because there's always something there that makes your situation different and sometimes rough to get working....

I had a quick look at dts, and managed to bash out a quick import. Thanks for the help unatratnag.

I don't suppose you know how to execute a dts package from a trigger do you? Are triggers an advisable way to execute a dts package that you don't want to have scheduled?

Thanks,

thanks for the help