i am writing my script to read from excel file the username and passwords information for my virtual users. however, when i follow the instructions on this reference page , i write the query as
a- Select Username from Sheet1
and it gives an error of "Microsoft Office Access base couldnt find object Sheet1. Make sure the object exists and its name and path is written correctly"
b- Select Username from Sheet1$
and it gives the error "Syntax error near from clause"
what can be the reason for this, and how should i solve this.
my excel file doesnt contain any tables, simply i created it writing the column names, and then under them, the column values for username, and passwords values. is this approach wrong ? how should i create and organize my excel file, or if it is correct, how can i overcome this error i receive.