sql - How to use stored procedure to get data from a table in xsl file which contains not only table? -

i have excel file need take data , insert into database table.

this file contains not data need. contains logo, information file , total amount subtotal of numbers in column.

i need have stored procedure reads data , ignores other stuff including logos, total , etc.

also, need insert data not exist yet. table insert has composite primary key (cardmember,yyyymm).

we going have 1 file every month 1 card member.

this example of image

enter image description here

i read posts not explain scenario.

how can this?

have tried using openrowset? can select range of cells want query.

select * openrowset( 'microsoft.ace.oledb.12.0', 'excel 12.0;hdr=yes;database=c:\yourfilepath', 'select * [sheet1$a5:f]') accountnumber not null

you can use clause on column have data exclude totals

JVParth