Uploading data from MS-XL to local db.......

[Former Member]

hi all,

i have a doubt while uploading data from XLS to my local database in DI-API.....In the below coding iam uploading data from the path Bin>Materials->Item1.xls, to my local db....here i have to hard-code the XL file name...is there any method by taking the XL file dynamically.....

FileName = System.AppDomain.CurrentDomain.BaseDirectory() & "\MATERIALS\Item1.xls"

     rs = oCompany.GetBusinessObject(BoObjectTypes.BoRecordset)
            objExcel = CreateObject("Excel.Application")
            objWrkBk = objExcel.Workbooks.Open(FileName)
            objSht = objWrkBk.Worksheets(1)

Regards,

shangai.

[Former Member · Accepted solution]

Hi Shanghai,

Let us have alook at this link:

http://support.microsoft.com/kb/q195951/

Her it is clearly explained about "

How To Query and Update Excel Data Using ADO From ASP"

I hope this will help u.....:)

Regards

Mohana

[Former Member]

Hi

Look this [thread|;.

Hope it help you.

Sierdna

[Former Member]

Hi,

Do u want to select the file by using a FILE browser ?? by using this u can select a file........

Or do u want to select a file frm a folder, without using a file browser..

search in google for "get a file in a folder in vb.net" and u'll get many examples,..

hope it helps,

Vasu Natari.

[Former Member]

hi vasu,

thanks,ur post helped me a lot...i solved my problem.

regards,

shangai.