wondering if there was a method to import a .dbf file into a dynamically named temp MSSQL table.

the hope is to work with all the data within my sql datasource. That said, I have been able to manually import the data using the DTS GUI, by using DBaseV as my dadtasource and then selecting the file. This is not a viable solution for me, because of the amount of daily occurrances in which this will be need.


IF there is any one that knows of a method whereby I can either convert the .dbf to some format that will allow me to bulkinsert the information or a way to set up a DTS on the fly please let me know

Thanks in advance,

AD