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

Ahhh the delights of the Excel driver

F1 is a column name in an Excel spreadsheet. Open one up and scroll to the
right.

Here are the answers to your other Qs

Excel treats First Row of Data as Headers
(http://www.sqldts.com/default.aspx?255)

Importing a Named Range From Microsoft Excel
(http://www.sqldts.com/default.aspx?243)

--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Lentyai" wrote in message
om...
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