-
Or, as Nick alluded to, why not use an SSIS task (2005's replacement for DTS) to import the data? In fact, I would imagine that you could cut the Excel (and Access) stages out altogether and get the data directly from your CSV files, performing the necessary filters & transformations along the...
-
kaak It may be better to look for SQL forums of newsgroups to ask your question as likely they would be more likely to control this process. If I were needing to do this however, I would be attacking this as an import from Excel from inside SQL. I only use SQL 2000 so use the old DTS route which was...