customer.sql

可以将 TDBGrid/TDataSet数据导入到Excel

  (2984, "Professional Divers, Ltd.", "4734 Melinda St.", "", "Hoover", "AL", "32145", "US", "205-555-8333", "205-555-4054", 0, "Shirley Mathers", "19940505");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (3041, "Divers of Blue-green", "634 Complex Ave.", "", "Pelham", "AL", "32145", "US", "205-555-7184", "205-555-6059", 0, "Nancy Bean", "18991230");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (3042, "Gold Coast Supply", "223-B Houston Place", "", "Mobile", "AL", "30696", "US", "205-555-2640", "205-555-4094", 0, "Elaine Falls", "19941207");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (3051, "San Pablo Dive Center", "1701-D N Broadway", "", "Santa Maria", "CA", "95443", "US", "823-044-2910", "823-044-2990", 0, "Patricia O'Brien", "18991230");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (3052, "Underwater Sports Co.", "351-A Sarasota St.", "", "San Jose", "CA", "92195", "US", "408-867-0594", "408-867-0094", 0, "Dave Walling", "18991230");

COMMIT;

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (3053, "American SCUBA Supply", "1739 Atlantic Avenue", "", "Lomita", "CA", "91770", "US", "213-654-0092", "213-654-0095", 0, "Lynn Cinciripini", "19950401");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (3054, "Catamaran Dive Club", "Box 264 Pleasure Point", "", "Catalina Island", "CA", "90740", "US", "213-223-0941", "213-223-2324", 0, "Nicole Dupont", "18991230");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (3055, "Diver's Grotto", "24601 Universal Lane", "", "Downey", "CA", "94220", "US", "213-432-0093", "213-432-4821", 0, "Peter Owen", "18991230");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (3151, "Fisherman's Eye", "PO Box 7542", "", "Grand Cayman", "", "", "British West Indies", "809-555-4680", "809-555-4689", 0, "Bethan Lewis", "19940108");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (3158, "Action Diver Supply", "Blue Spar Box #3", "", "St. Thomas", "", "00820", "US Virgin Islands", "22-44-500211", "22-44-500596", 0, "Marianne Miles", "18991230");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (3615, "Marina SCUBA Center", "PO Box 82438 Zulu 7831", "", "Caracas", "", "", "Venezuela", "58-33-66222", "58-33-66049", 0, "Stephen Bryant", "19931105");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (3984, "Blue Glass Happiness", "6345 W. Shore Lane", "", "Santa Monica", "CA", "90410", "US", "213-555-1984", "213-555-1995", 0, "Christine Taylor", "19940212");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (4312, "Divers of Venice", "220 Elm Street", "", "Venice", "FL", "39224", "US", "813-443-2356", "813-443-9842", 0, "Simone Green", "18991230");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (4531, "On-Target SCUBA", "7-73763 Nanakawa Road", "", "Winnipeg", "Manitoba", "J2R 5T3", "Canada", "416-445-0988", "416-445-0223", 0, "Bram Phillips", "19940901");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (4652, "Jamaica Sun, Inc.", "PO Box 643", "", "Runaway Bay", "Jamaica", "", "West Indies", "809-555-2746", "809-555-0929", 0, "Jonathan West", "18991230");

COMMIT;

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (4684, "Underwater Fantasy", "PO Box 842", "", "Ocho Rios", "Jamaica", "", "West Indies", "809-555-2214", "809-555-2234", 0, "Grant Ainsworth", "18991230");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (5132, "Princess Island SCUBA", "PO Box 32 Waiyevo", "", "Taveuni", "", "", "Fiji", "679-311923", "679-311203", 0, "Anne Mariachi", "18991230");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (5151, "Central Underwater Supplies", "PO Box 737", "", "Johannesburg", "", "2042", "Republic So. Africa", "27-11-4432458", "27-11-4433259", 0, "Maria Eventosh", "18991230");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (5163, "Safari Under the Sea", "PO Box 7456", "", "Grand Cayman", "", "", "British West Indies", "809-409-4233", "809-409-3002", 0, "Anna Rack", "18991230");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (5165, "Larry's Diving School", "3562 NW Bruce Street", "", "Milwaukie", "OR", "96277", "US", "503-403-7777", "503-403-0059", 0, "Isabelle Neece", "18991230");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (5384, "Tora Tora Tora", "PO Box H-4573", "", "Nassau", "", "", "Bahamas", "809-898-0043", "809-898-9864", 0, "Kevin Rider", "19950502");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (5412, "Vashon Ventures", "743 Keyhole Court", "", "Honolulu", "HI", "92856", "US", "532-099-0423", "532-099-6654", 0, "Susan Smith", "18991230");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (5432, "Divers-for-Hire", "G.O. P Box 91", "", "Suva", "", "", "Fiji", "679-804576", "679-059345", 0, "Joe Hatter", "18991230");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (5515, "Ocean Adventures", "PO Box 466 Kihei", "", "Maui", "HI", "95736", "US", "776-868-9334", "776-868-9553", 0, "Paul Still", "19950801");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (6215, "Underwater SCUBA Company", "PO Box Sn 91", "", "Somerset", "", "SXBN", "Bermuda", "809-555-1225", "809-555-2445", 0, "Michael Grossman", "19940704");

COMMIT;

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (6312, "Aquatic Drama", "921 Everglades Way", "", "Tampa", "FL", "30643", "US", "613-442-7654", "613-442-7678", 0, "Gillian Owen", "18991230");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (6516, "The Diving Company", "PO Box 8535", "", "St. Thomas", "", "00820", "US Virgin Islands", "22-44-50098", "22-44-09878", 0, "Brian Miles", "18991230");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (6582, "Norwest'er SCUBA Limited", "PO Box 6834", "", "Paget", "", "PSBZ", "Bermuda", "778-123-0745", "778-123-9705", 0, "Angela Jones", "19950302");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (6812, "Waterspout SCUBA Center", "7865 NE Barber Ct.", "", "Portland", "OR", "99271", "US", "503-654-2434", "503-654-9986", 0, "Richard Houser", "19941110");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (9841, "Neptune's Trident Supply", "PO Box 129", "", "Negril", "Jamaica", "", "West Indies", "778-897-3546", "778-897-6643", 0, "Louise Franks", "19950111");