# How to import excel file with field name in row number 6 into Oracle Db

**URL:** <https://forums.toadworld.com/t/how-to-import-excel-file-with-field-name-in-row-number-6-into-oracle-db/6131>\
**Category:** Toad Data Point & Toad Intelligence Central\
**Created:** [February 2, 2010, 3:49am UTC](https://forums.toadworld.com/t/how-to-import-excel-file-with-field-name-in-row-number-6-into-oracle-db/6131 "2010-02-02T03:49:29Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![tobyZiegler](https://avatars.discourse-cdn.com/v4/letter/t/f14d63/32.png) [@tobyZiegler](https://forums.toadworld.com/u/tobyZiegler)\
**Post date:** [February 2, 2010, 3:49am UTC](https://forums.toadworld.com/t/how-to-import-excel-file-with-field-name-in-row-number-6-into-oracle-db/6131/1 "2010-02-02T03:49:29Z")

</div>

Hi,  
I have excel file with fieldnames in sixth row (cf attached file). So I specify that the column name is the header row and that the data begin in row 6 (see presse-papiers1.png). But in the File preview, the fieldname is still the 1st row (see presse-papier3.png). What do I missed ?  
Thanks in advance,

P.S. and here’s the result : see attachment presse-papier4.png  
Message was edited by: tobyZiegler

BTX\_IC\_ACT\_2006\_IRIS.xls (258 KB)

![Presse-papiers-1.png](https://global.discourse-cdn.com/quest/original/2X/5/51b4f6cf874759e1df972dfeaa0e593a1f3363b0.png)

![Presse-papiers-2.png](https://global.discourse-cdn.com/quest/original/2X/7/780f9ece828770f24e48f079fbae173cf3739803.png)

![Presse-papiers-3.png](https://global.discourse-cdn.com/quest/original/2X/1/159620c8231a1edc509f806702d6d2c660156e6a.png)

![Presse-papiers-4.png](https://global.discourse-cdn.com/quest/original/2X/c/c5400e0d318414da79219328f774cf51457b0ec7.png)

---

<div class="post-metadata">

**Author:** ![Debbie\_Peabody](https://sea1.discourse-cdn.com/quest/user_avatar/forums.toadworld.com/debbie_peabody/32/18_2.png) [@Debbie\_Peabody](https://forums.toadworld.com/u/Debbie_Peabody)\
**Post date:** [February 2, 2010, 10:56am UTC](https://forums.toadworld.com/t/how-to-import-excel-file-with-field-name-in-row-number-6-into-oracle-db/6131/2 "2010-02-02T10:56:25Z")

</div>

Yes. We are not seeing the headers on the line 6. I entered CR70840 to be fixed in the next release. We are planning on enhancements to mapping of rows and data for Excel files. This is for the 3.0 release.

For now the work around is to import into an already existing table and point to row 7 as data without headers.

Debbie