Loading .accdb header lines issue

[saumyashah90]

Hi All,

I connected with OLEDB connection and also loaded contents but i faced one problem is

Header 1	Header 2	Header 3
Date	First Name	Last Name
231213	abc	ghi
123123	def	jkl

In here I have header1 ,2,3 as my forst row as a header row and same thing remains when i load it in qlikview.

I also tried loading it into qvd and then loaded it again but same problem(i could do the transformations but was not able to make required line as header row)

I could didnt get header line option as we get in normal excel load.

Please guide me in gettin Date,First Name and Last Name as my header row .

[marcus_sommer]

Header1 as Date (and so on) with a preceding load - don't worked?

- Marcus

[saumyashah90]

Hey Marcus,

This is wont be possible for me, i have 100's of fields and not only one sheet...i have  many sheets with that number of fields.I need not make any changes in data or format.

[anandathome]

Can you check you have similar settings as attached?

[saumyashah90]

Yes its a same setting.

Like you have field names getting loaded, I have F1,F2,F3 and so on because i have main field names in 3rd or 4th row.

[marcus_sommer]

You could build from the first and second row a mapping table (perhaps per cross table or in a loop) and use this table for a rename-statement.

rename table (using mapname | altername to neuername { , altername to neuername } )

- Marcus

[ravishankarqv]

Hi Saumya,

Are you sure that you have date in MS Acccess (accdb) properly defined? If you can see data in MS Access as in attached, you should not have any problem in Qlikview Loading.

First One is Table View and second on is Design View on MS ACCESS

HTH

Ravi