customer.sql

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

CREATE TABLE customer (
   CUSTNO DECIMAL NULL, 
   COMPANY CHAR(31) NULL, 
   ADDR1 CHAR(31) NULL, 
   ADDR2 CHAR(31) NULL, 
   CITY CHAR(16) NULL, 
   STATE CHAR(21) NULL, 
   ZIP CHAR(11) NULL, 
   COUNTRY CHAR(21) NULL, 
   PHONE CHAR(16) NULL, 
   FAX CHAR(16) NULL, 
   TAXRATE DECIMAL NULL, 
   CONTACT CHAR(21) NULL, 
   LASTINVOIC DATETIME NULL);

/*    SMExport suite generator    */
/*        Scalabium Software      */
/*    http://www.scalabium.com    */
/*                                */
/*    INSERT-statements with      */
/*   data dump from DBF (Delphi)  */
/*                                */
INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (1221, "Kauai Dive Shoppe", "4-976 Sugarloaf Hwy", "Suite 103", "Kapaa Kauai", "HI", "94766-1234", "US", "808-555-0269", "808-555-0278", 8.5, "Erica Norman", "19950202");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (1231, "Unisco", "PO Box Z-547", "", "Freeport", "", "", "Bahamas", "809-555-3915", "809-555-4958", 0, "George Weathers", "18991230");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (1351, "Sight Diver", "1 Neptune Lane", "", "Kato Paphos", "", "", "Cyprus", "357-6-876708", "357-6-870943", 0, "Phyllis Spooner", "18991230");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (1354, "Cayman Divers World Unlimited", "PO Box 541", "", "Grand Cayman", "", "", "British West Indies", "011-5-697044", "011-5-697064", 0, "Joe Bailey", "18991230");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (1356, "Tom Sawyer Diving Centre", "632-1 Third Frydenhoj", "", "Christiansted", "St. Croix", "00820", "US Virgin Islands", "504-798-3022", "504-798-7772", 0, "Chris Thomas", "18991230");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (1380, "Blue Jack Aqua Center", "23-738 Paddington Lane", "Suite 310", "Waipahu", "HI", "99776", "US", "401-609-7623", "401-609-9403", 0, "Ernest Barratt", "19940811");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (1384, "VIP Divers Club", "32 Main St.", "", "Christiansted", "St. Croix", "02800", "US Virgin Islands", "809-453-5976", "809-453-5932", 0, "Russell Christopher", "19950102");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (1510, "Ocean Paradise", "PO Box 8745", "", "Kailua-Kona", "HI", "94756", "US", "808-555-8231", "808-555-8450", 0, "Paul Gardner", "19940911");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (1513, "Fantastique Aquatica", "Z32 999 #12A-77 A.A.", "", "Bogota", "", "", "Columbia", "057-1-773434", "057-1-773421", 0, "Susan Wong", "18991230");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (1551, "Marmot Divers Club", "872 Queen St.", "", "Kitchener", "Ontario", "G3N 2E1", "Canada", "416-698-0399", "426-698-0399", 0, "Joyce Marsh", "19900707");

COMMIT;

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (1560, "The Depth Charge", "15243 Underwater Fwy.", "", "Marathon", "FL", "35003", "US", "800-555-3798", "800-555-0353", 0, "Sam Witherspoon", "19940904");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (1563, "Blue Sports", "203 12th Ave. Box 746", "", "Giribaldi", "OR", "91187", "US", "610-772-6704", "610-772-6898", 0, "Theresa Kunec", "19910905");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (1624, "Makai SCUBA Club", "PO Box 8534", "", "Kailua-Kona", "HI", "94756", "US", "317-649-9098", "317-649-6787", 0, "Donna Siaus", "19950701");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (1645, "Action Club", "PO Box 5451-F", "", "Sarasota", "FL", "32274", "US", "813-870-0239", "813-870-0282", 0, "Michael Spurling", "18991230");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (1651, "Jamaica SCUBA Centre", "PO Box 68", "", "Negril", "Jamaica", "", "West Indies", "011-3-697043", "011-3-697043", 0, "Barbara Harvey", "18991230");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (1680, "Island Finders", "6133 1/3 Stone Avenue", "", "St Simons Isle", "GA", "32521", "US", "713-423-5675", "713-423-5676", 0, "Desmond Ortega", "19950201");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (1984, "Adventure Undersea", "PO Box 744", "", "Belize City", "", "", "Belize", "011-34-09054", "011-34-09064", 0, "Gloria Gonzales", "19940611");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (2118, "Blue Sports Club", "63365 Nez Perce Street", "", "Largo", "FL", "34684", "US", "612-897-0342", "612-897-0348", 0, "Harry Bathbone", "19900806");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (2135, "Frank's Divers Supply", "1455 North 44th St.", "", "Eugene", "OR", "90427", "US", "503-555-2778", "503-555-2769", 0, "Lloyd Fellows", "18991230");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (2156, "Davy Jones' Locker", "246 South 16th Place", "", "Vancouver", "BC", "K8V 9P1", "Canada", "803-509-0112", "803-509-0553", 0, "Tanya Wagner", "19910511");

COMMIT;

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (2163, "SCUBA Heaven", "PO Box Q-8874", "", "Nassau", "", "", "Bahamas", "011-32-09485", "011-32-09485", 0, "Robert Michelind", "18991230");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (2165, "Shangri-La Sports Center", "PO Box D-5495", "", "Freeport", "", "", "Bahamas", "011-32-08574", "011-32-44938", 0, "Frank Paniagua", "19890307");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (2315, "Divers of Corfu, Inc.", "Marmoset Place 54", "", "Ayios Matthaios", "Corfu", "", "Greece", "30-661-88364", "30-661-05943", 0, "Charles Lopez", "18991230");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (2354, "Kirk Enterprises", "42 Aqua Lane", "", "Houston", "TX", "77079", "US", "713-556-6437", "713-556-1073", 0, "Rudolph Claus", "19940802");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES
  (2975, "George Bean & Co.", "#73 King Salmon Way", "", "Lugoff", "NC", "29078", "US", "803-438-2771", "803-438-3003", 0, "Bill Wyers", "19940604");

INSERT INTO customer
  (CUSTNO, COMPANY, ADDR1, ADDR2, CITY, STATE, ZIP, COUNTRY, PHONE, FAX, TAXRATE, CONTACT, LASTINVOIC)
VALUES