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
Vinod,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,
Eric
-- Anonymous, September 09, 2000