excel based bom

I make a API ( VB.NET) to extract the bom to a extern database ( ACCESS 2007 ).  I try to found the way to extract the info of a EXCEL based bom, put it in a ARRAY VARIABLE, and transfert the info to a ACCES 2007 database.   I think is the GETBOMTABLE, but i don't know How ti use it.  I know how to make the connection to the database.

Someone can help me.

Excuse my english, I'am a french guy.

SolidworksApi macros