Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a question on the usage of excel sheets as query input.
Suppose I have a database containing persons (defined by an ID, column 1). For every person a birthday is associated (column 2).
Can I use an excel sheet as input for querying the database, returning me the birthdates of the persons listed in the excel sheet? The persons in the excel sheet are a subset of all possible persons.
I can not get it done...
The goal is to implement an automated query mechanism that yields results for the entries of the excel sheet.
Thanks in advance,
Sasha
Hello , You can read the Excel sheets names and birthdates into first table and then you can fetch the values from the database into the second table using the first tables anmes or Birthdates.