Hi, all!

When I'm trying to import data from Excel using DTS object in VB one
of the params specified a
oCustomTask1.SourceSQLStatement = "select `F1` from `'Sheet1$'`"
What is F1?
Actually what I need is to specify a range of cells in the Excel to
import into SQL tables. This could be a whole column, part of an excel
column or part of data on the sheet. How can I do this?

Another problem is that while using the procedure I've taken from
aoutomatic generation of VB file from SQL is that the data that is
being imported always loses the first line of data. For instance I
have 61 rows in the Excel file but get only 60 records in the SQL
table, losing the first one on the way.


Thanks a lot for Help,
Ilya