Transfer data from .dbf file to SQL Server 2000
I need to write an SQL scripts to transfer data from .dbf file into the database. The script to able to read the data file from the CD/DVD drive and dump in the database table. The name of the data file on the cd is unique and its same on every CD. There should be 2 different scripts one for Imports and one for Exports. Also the original data table on the CD has about 20-30 columns and we will be using only 5-8 columns(predefine).
|
