no of rows

[sony123]

Hi,
i have an abc excel...and it is uploading xyz excel,that excel is writing into database...

iam uploading xyz excel into abc excel (using browse and upload command buttons)..

That xyz excel writes into database.....

Ex: if my xyz file has 100 rows...
While uploading read rows from xyz file is say 100...i need to display message like( no of rows read:100)
and the xyz excel is writing into database...
While inserting into database,no of rows inserted let us say 90 only..message( no of rows inserted :90)
If both are not same...pop up message some rows are not inserted...
and the failed records need to be displayed in separate sheet....
Thank you...

 

[SirJB7]

Hi, sony123!
Am I wrong or your file is empty?
Regards!

 

[sony123]

No...Code is there in my excel..which i uploaded...
Go to VBA code...

 

[sony123]

Code is there..u can check in vba...

 

[Hui]

Sony123
SirJB7 was correct, You have saved a blank file!
Download it yourself and check
If you add code you must save the file as a *.xlsm or *.xlsb file type