Import Excel

SQL 2k, sp4
Using DTS, I'm trying to import an Excel file. The file is essentially a
report exported into Excel. I have a title in Row A1, some blank rows, then
headings starting in Row 11. Col A - K contain data. Col A has the
equivalent of movie titles. When I "preview" during the import process,
there is no data showing up in the rows except for the titles. If I look at
the Excel file in Excel, I see data in each of the cells correctly. If I
save as a csv, I see all the data. Unfortunately, I don't have the option
of saving these files as csv; they must remain as Excel files. Does anyone
have any suggestions for how I can get the data to show up in Excel?
Thanks in advance,
AndreCopy the data from spreadsheet into another blank workbook and name the
worksheet. Create column names for each column and use DTS to import in DTS
map each column in the excel to correspond with the database columns.
"Andre" wrote:

> SQL 2k, sp4
> Using DTS, I'm trying to import an Excel file. The file is essentially a
> report exported into Excel. I have a title in Row A1, some blank rows, th
en
> headings starting in Row 11. Col A - K contain data. Col A has the
> equivalent of movie titles. When I "preview" during the import process,
> there is no data showing up in the rows except for the titles. If I look
at
> the Excel file in Excel, I see data in each of the cells correctly. If I
> save as a csv, I see all the data. Unfortunately, I don't have the option
> of saving these files as csv; they must remain as Excel files. Does anyon
e
> have any suggestions for how I can get the data to show up in Excel?
> Thanks in advance,
> Andre
>
>|||Hi!!! I don't speak english very well, but I believe that the solution to
this problem is in the next page:
http://www.sqldts.com/default.aspx?254
Bye!!!
"Andre" wrote:

> SQL 2k, sp4
> Using DTS, I'm trying to import an Excel file. The file is essentially a
> report exported into Excel. I have a title in Row A1, some blank rows, th
en
> headings starting in Row 11. Col A - K contain data. Col A has the
> equivalent of movie titles. When I "preview" during the import process,
> there is no data showing up in the rows except for the titles. If I look
at
> the Excel file in Excel, I see data in each of the cells correctly. If I
> save as a csv, I see all the data. Unfortunately, I don't have the option
> of saving these files as csv; they must remain as Excel files. Does anyon
e
> have any suggestions for how I can get the data to show up in Excel?
> Thanks in advance,
> Andre
>
>