All

I am currently working on a way of importing some excel spreadsheets
into MS SQL.

Although the spreadsheets are structured visually, they are not very
import friendly as there are several tables worth of information below
each other on a given sheet, and also the heading information for each
column is not the first item in the spreadsheet (and some of the
heading information spreads over two or more rows).

Further to this, the data will have to be imported every month, and so
if data is added to the top table, the location of the lower table is
changed. The data files are not that large, as excel sheets the
largest is 800k.

In your opinion would it be worth trying to work something in DTS to
import the data, or would it be better to work on some other method
(eg, write some VB code). If working with another method, would any
suggestions spring immediately to mind?

Many thanks in advance

Lewis