In the preference menu, I'm not able to chose an Excel database. How can I read an Excel database ? thanks for your help.

You need an ODBC Excel driver and configured "ODBC Data Source". Then in the 24x7 Database Profiles you would select ODBC as a database and create a new profile for the configured ODBC Source.

: In the preference menu, I'm not able to chose an Excel database. How can I
: read an Excel database ? thanks for your help.

It's done, but when I want my job to access to a specified table with the command "DatabaseImport", the soft return me :"Result set is not updatable, specified table must have a primary key" whereas I've already defined a primary key for my table... any idea about this error ?

Excel is not really a database system and it does not have tables and primary keys, therefore you cannot use DatabaseImport or any other "updateable" operation. If you intend to load some data into Excel you should use direct Excel automation using either Excel COM interface or Excel macros or by manipulating Excel using keystrokes.

For Excel COM automation, see "Excel Automation" example in 24x7 v.3 and also the 24x7 online help for Visual Basic Script

For Excel Macros see Excel on-line help on macros that run whenever you open a workbook. So when you start Excel with a template (or file containing macro) in the command line parameter, that macro will run and do the "import" job.

For keystrokes, see "Send Keystrokes" topic in the 24x7 on-line help.

: It's done, but when I want my job to access to a specified table with the
: command "DatabaseImport", the soft return me :"Result set
: is not updatable, specified table must have a primary key" whereas
: I've already defined a primary key for my table... any idea about this
: error ?