Unable to create load testing variable using excel

Question

I am unable to create load testing variable using excel.

I have used excel connection string, but when the wizard for selecting database object is displayed, sheetnames of the excel sheet i have selected are displayed in the list box but when i click on next i am getting an error "unable to retrieve data from the specified database object. the database engine reports: syntax error in FROM clause.

Please see the attachment for more details

radov · Answer

Hi Sowmya,Please try to enclose the sheet name in brackets after selecting it from the drop-down box (for instance, [Sheet1$]) and then click Next. Does this help?Also, go through the following threads where you can find some more information about filling in load testing variables with data from Excel sheets:http://smartbear.com/forums/forum/post/?mode=singleThread&amp;thread=58128648-e190-40c8-ba5e-a5576d647a34http://smartbear.com/forums/forum/post/?mode=singleThread&amp;thread=8fa29cc1-d0a1-4cf9-9878-9de9c2a997b2

sowmyam · Answer

Thanks.it worked when i enclosed the sheetname in bracketsSowmya

Forum Discussion

Unable to create load testing variable using excel

2 Replies

Related Content

Test Complete / Variables

Unable to recognize a button in LoadNinja

Azure Pipeline - Variables Not passed to my test

keyword test; variable of type object; store DateTime in keyword variable - javascript

Search/Highlight Variable in Keyword Testing

Recent Discussions

How do I determine what is different between two different xlsx versions of the same worksheet?

Log.Error supressing Log.Warning in Execution Summary

Edge browser compatibility

Delay after pressing specific Key

Connecting to license manager behind a home router?