populate database with xls file uploading

 

hii all,

        i need to populate my database by xls file, means when i upload xls file thru file uploading system, my database shud be populated with the values in xls file and old data shud be removed first. first of all i tried to make a folder like given below...
string MyPath;
string MyName;

// Display the names in D:\ that represent directories.

 

MyPath = "D:\\debit_credit\\";

// Set the path.

MyName = FileSystem.Dir(MyPath, Constants.vbDirectory);

 

// Retrieve the first entry.

 
< ...