SQL Script for importing data

If you have Enterprise Manager you can use a Data Transformation Services (DTS) Wizard to do the import and a query to specify the date range during import.

Depends on what you are using for an MIS server. Some environments will give you an import facility, others don't. Once you've got the file into a table, querying it should be relatively easy.

Using DTS in Enterprise Manager is most certainly the easiest way to get the data into SQL - either the complete table as is or filtering the data with a select statement. You can even schedule up the job to run out of hours if server/database usage is high in normal hours. And you can use it to transfer data to/from lots of other sources as well. Well worth time investigating.

This question was closed by the author