On-the fly creation of dbf files from result sets?

greenspun.com : LUSENET : SQL Server Database Administration : One Thread

Hi, I am currently working on a custom GIS application that requires the use of data in dbf format. I am storing the data in SQL Server 7.0 and have stored procedures that performs some computations on the data to yield a result set based on user parameters. I need to take these results (that in a #temp table) and convert it to dbf format giving it a unique file name every time the stored procedure is run. Any ideas or thoughts?

Thanks, Vinod

-- Anonymous, September 08, 2000



DBF is the dBASE file format. (See http://www.apptools.com/dbase/faq/qformt.htm for the gory details.)

Use the DTS Wizard to export a database in dBASE file format. You will need to experiment to determine if you need dBASE III, IV, or 5 format.

With my SQL 7.5 Beta 1 installation, I invoke the DTS Wizard by selecting 'Import and Export Data' from the SQL program folder.

Good Luck,


-- Anonymous, September 09, 2000

Moderation questions? read the FAQ