Using Excel to generate test data for Sql tables

[Ida Achi]

I just need a direction, ideas on how and where to begin.
I need to use Excel to write test cases for a database with several tables. What should I be looking for?
For instance can I write test data in excel for table below? Please help. Thanks



- Table `viterra`.`partner`
-- -----------------------------------------------------

DROP TABLE IF EXISTS `viterra`.`partner` ;

CREATE  TABLE IF NOT EXISTS `viterra`.`partner` (

  `p_nr` BIGINT(16) UNSIGNED NOT NULL ,
  `dkz` VARCHAR(1)  NOT NULL,
  `ansprechpartner` VARCHAR(255) NOT NULL ,
  `ansprechpartner2` VARCHAR(50) NULL ,
  `bankname` VARCHAR(50) NOT NULL ,
  `blz` BIGINT(8)  NOT NULL ,
  `email` VARCHAR(50)  NULL ,
  `email2` VARCHAR(50)  NULL ,
  `faxnummer` VARCHAR(50)  NULL ,
  `faxnummer2` VARCHAR(50)  NULL ,
  `hausnummer` BIGINT(4) NOT NULL ,
  `kontonummer` BIGINT(12) NOT NULL ,
  `ort` VARCHAR(50) NOT NULL ,
  `info` VARCHAR(2000)  NULL ,
  `partnertyp` VARCHAR(16)NOT  NULL ,
  `beschreibung` VARCHAR(50) NOT NULL ,
  `vgultig_ab` DATETIME NOT NULL,
  `vertragsnummer_intern` BIGINT(9) UNSIGNED NOT NULL ,
  `name` VARCHAR(50) NOT  NULL ,
  `plz` BIGINT(5) UNSIGNED NOT NULL ,
  `strasse` VARCHAR(50) NOT NULL ,
  `telefonnr1` VARCHAR(50) NOT NULL ,
  `telefonnr2` VARCHAR(50) NULL ,
  `datumzeit` DATETIME NOT NULL ,
  `gb_nr` BIGINT(16) UNSIGNED NOT NULL ,
  PRIMARY KEY (`p_nr`,`dkz`))



ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;

[Lester Burnham]

What role would Excel -or Excel files- play in this scenario? Are you using JUnit with something like DBUnit or SQLUnit?

[Ida Achi]

All I have is a MySQL database with a couple of tables. I need to use Excel to generate test cases ( stored procedure test, type test, data size test, input verification) for the database. No Junit or SQL unit.
Is this even possible?

[Lester Burnham]

The question was really: why do you need to use Excel? What particular features does Excel have that help with DB testing? Or, to put it in yet another way: How do you intend to test the DB with whatever data/information ends up in Excel?