Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
EdwinGene
Starting Member
2 Posts |
 Posted - 2004-10-27 : 14:21:57
|
| This may be a very simple question, but up until now I have only imported and exported flat text files using the DTS Transform Data Task.I created a small, simple Excel spreadsheet (using version Excel2002). When I attempted to import the spreadsheet into SQL Server using the Transform Data Task, the first row of the spreadsheet was omitted. I checked the Transform Data Task and Excel Connection properties but could not find anyplace which would designate the first row of the spreadsheet as a header row or not a header row. So, why is the first row of the spreadsheet being omitted in the import?Thanks. |
|
|
nreinholdt
Starting Member
8 Posts |
Posted - 2004-10-30 : 19:14:08
|
| Hmmm. Normally when you export to Excel the first row is a header row, so my first thought would be to use a header row in your worksheet. I don't believe there are any options to enable/disable this, and suspect that Excel sheets will always have the first row treated as a header row. Those values would normally show up in the Transformation page's "Source" list.Just in case you haven't checked this: in the "Transform Data Task" check your "Options" page to ensure that "First Row" and "Last Row" are set to 0.Good luck!nragamuffin |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2004-10-31 : 02:27:21
|
| http://www.sqldts.com/default.aspx?255Kristen |
|
|
|
EdwinGene
Starting Member
2 Posts |
Posted - 2004-11-01 : 10:59:33
|
Kristen,Thank you so much, that worked perfectly. |
|
|
|
|
|
|
Excel Spreadsheet Import Problem