how to import a multi- row Excel table into an Access DB

[ahmed sami]

Hi all, I have already asked this question but no one answered me clearly... I have an Excel table with more than one row headings (merged in some places and kept intact in other ones) ... I want to have this table imported to my Access DB..but there is no option during import wizard that allows Access to be compatible with such table (only the option"First Row Contains Column Headings") .. is it possible to find another method to make Access DB identify such table or I have to eliminate these headings into one row? Thanks.

[abusaif]

Sorry Brother,

As per to my knowledge No. You can have only one column headings. But I am wondering why you want 2 Headings?

[ahmed sami]

Sorry Brother,

As per to my knowledge No. You can have only one column headings. But I am wondering why you want 2 Headings?

Because my own Excel table has more than one row headings