Not Able To Import Excel, MDB To SQL 2005

I need to create an application to import several text, excel and mdb files into SQL2005. I created a c# application to dynamically create a package & import text files but not able to do the same with excel and mdb files.
I guess i am not giving the right connections. Any help on this please........

//Create connections

//Source Connection

IDTSComponentMetaData90 ExcelSource;

IDTSComponentMetaData90 oledbDestination;

MainPipe dataFlow;

//Add connections

ConnectionManager conMgr = pkg2.Connections.Add("OLEDB");

ConnectionManager EconMgr = pkg2.Connections.Add("EXCEL");

/// Set stock properties

conMgr.Name = "OLEDBConnection";

conMgr.ConnectionString = ConnString;//



//Set stock properties

EconMgr.Name = "ExcelConnection";

EconMgr.ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + InputfileLoc +

";Extended Properties=Excel 8.0;HDR=YES;";

TaskHost th = pkg2.Executables.Add("DTS.Pipeline") as TaskHost;

th.Name = "DataFlow";

dataFlow = th.InnerObject as MainPipe;

// set source component

ExcelSource = dataFlow.ComponentMetaDataCollection.New();

ExcelSource.ComponentClassID = "DTSAdapter.ExcelSource";

ExcelSource.Name = "ExcelSource";

CManagedComponentWrapper instanceSource = ExcelSource.Instantiate();

ExcelSource.RuntimeConnectionCollection.New();

ExcelSource.RuntimeConnectionCollection[0].ConnectionManagerID = pkg2.Connections["ExcelConnection"].ID;

ExcelSource.RuntimeConnectionCollection[0].ConnectionManager = DtsConvert.ToConnectionManager90(pkg2.Connections["ExcelConnection"]);

instanceSource.ProvideComponentProperties();

instanceSource.SetComponentProperty("OpenRowset", "book1");

instanceSource.SetComponentProperty("AccessMode", 0);

// Acquire Connections and reinitialize the component

instanceSource.AcquireConnections(null); -----I am failing here with a com exception
instanceSource.ReinitializeMetaData();

instanceSource.ReleaseConnections();

//set destination component

oledbDestination = dataFlow.ComponentMetaDataCollection[1];

if (oledbDestination.RuntimeConnectionCollection.Count > 0)

{

oledbDestination.RuntimeConnectionCollection[0].ConnectionManager = DtsConvert.ToConnectionManager90(pkg2.Connections["OLEDBConnection"]);

oledbDestination.RuntimeConnectionCollection[0].ConnectionManagerID = pkg2.Connections["OLEDBConnection"].ID;

}

CManagedComponentWrapper instanceDest = oledbDestination.Instantiate();

instanceDest.SetComponentProperty("OpenRowset", desttable);

instanceDest.SetComponentProperty("AccessMode", 0);

// Acquire Connections and reinitialize the component

instanceDest.AcquireConnections(null);

instanceDest.ReinitializeMetaData();

instanceDest.ReleaseConnections();

IDTSInput90 input = oledbDestination.InputCollection[0];

IDTSVirtualInput90 vInput = input.GetVirtualInput();

foreach (IDTSVirtualInputColumn90 vColumn in vInput.VirtualInputColumnCollection)

{

IDTSInputColumn90 vCol = instanceDest.SetUsageType(input.ID, vInput, vColumn.LineageID, DTSUsageType.UT_READWRITE);

instanceDest.MapInputColumn(input.ID, vCol.ID, input.ExternalMetadataColumnCollection[vColumn.Name].ID);

}

//string currentDirectory = System.IO.Directory.GetCurrentDirectory();

a.SaveToXml(Pacloc, pkg2, null);