home *** CD-ROM | disk | FTP | other *** search
| Unknown | 1998-05-26 | 26.9 KB |
open in: 
MacOS 8.1
|
Win98
|
DOS
view JSON data
|
view as text
This file was not able to be converted.
This format is not currently supported by dexvert.
hex view+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 00 6b 6d 00 00 00 01 | 00 00 00 00 00 00 00 00 |..km....|........|
|00000010| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000040| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000050| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000060| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000070| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000080| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000090| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000000f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000100| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000110| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000120| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000130| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000140| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000150| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000160| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000170| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000180| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000190| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000001f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000200| 00 00 00 01 00 00 00 10 | 56 45 52 53 49 4f 4e 20 |........|VERSION |
|00000210| 3d 20 20 20 33 2e 30 30 | 00 00 00 01 00 00 00 14 |= 3.00|........|
|00000220| 01 00 0a 00 70 69 76 74 | 61 62 6c 65 2e 68 92 b2 |....pivt|able.h..|
|00000230| 00 00 5f 23 00 00 00 01 | 00 00 00 0a 70 69 76 6f |.._#....|....pivo|
|00000240| 74 74 61 62 6c 65 00 00 | 00 01 00 00 00 0a 70 69 |ttable..|......pi|
|00000250| 76 74 61 62 6c 65 2e 68 | 00 00 00 01 00 00 00 06 |vtable.h|........|
|00000260| 50 69 78 65 6c 73 00 00 | 00 01 00 00 00 05 43 6c |Pixels..|......Cl|
|00000270| 61 73 73 00 00 00 01 00 | 00 00 01 31 00 00 00 01 |ass.....|...1....|
|00000280| 00 00 00 0a 61 75 74 6f | 6d 61 74 69 6f 6e 00 00 |....auto|mation..|
|00000290| 00 01 00 00 00 0a 70 69 | 76 6f 74 74 61 62 6c 65 |......pi|vottable|
|000002a0| 00 00 00 01 00 00 02 84 | 73 6b 69 70 65 72 72 6f |........|skiperro|
|000002b0| 72 0d 0a 63 68 65 63 6b | 73 74 61 74 65 20 66 6c |r..check|state fl|
|000002c0| 61 67 20 74 6f 20 74 65 | 73 74 20 73 74 61 74 65 |ag to te|st state|
|000002d0| 20 6f 66 20 45 78 63 65 | 6c 20 76 69 61 20 45 72 | of Exce|l via Er|
|000002e0| 72 6f 72 20 72 6f 75 74 | 69 6e 65 0d 0a 63 70 69 |ror rout|ine..cpi|
|000002f0| 76 66 6c 64 72 6f 77 20 | 4e 61 6d 65 20 6f 66 20 |vfldrow |Name of |
|00000300| 66 69 65 6c 64 20 66 6f | 72 20 70 69 76 6f 74 20 |field fo|r pivot |
|00000310| 74 61 62 6c 65 20 72 6f | 77 2e 0d 0a 63 70 69 76 |table ro|w...cpiv|
|00000320| 66 6c 64 63 6f 6c 20 4e | 61 6d 65 20 6f 66 20 66 |fldcol N|ame of f|
|00000330| 69 65 6c 64 20 66 6f 72 | 20 70 69 76 6f 74 20 74 |ield for| pivot t|
|00000340| 61 62 6c 65 20 63 6f 6c | 75 6d 6e 2e 0d 0a 63 70 |able col|umn...cp|
|00000350| 69 76 66 6c 64 70 61 67 | 65 20 4e 61 6d 65 20 6f |ivfldpag|e Name o|
|00000360| 66 20 66 69 65 6c 64 20 | 66 6f 72 20 70 69 76 6f |f field |for pivo|
|00000370| 74 20 74 61 62 6c 65 20 | 70 61 67 65 2e 0d 0a 6e |t table |page...n|
|00000380| 61 63 74 69 6f 6e 20 4f | 75 74 70 75 74 20 61 63 |action O|utput ac|
|00000390| 74 69 6f 6e 20 28 31 2d | 45 78 63 65 6c 20 73 68 |tion (1-|Excel sh|
|000003a0| 65 65 74 2c 20 32 2d 56 | 46 50 20 66 6f 72 6d 29 |eet, 2-V|FP form)|
|000003b0| 2e 0d 0a 63 66 6f 72 6d | 73 63 78 0d 0a 63 66 6f |...cform|scx..cfo|
|000003c0| 72 6d 6e 61 6d 65 0d 0a | 63 70 69 76 66 6c 64 64 |rmname..|cpivfldd|
|000003d0| 61 74 61 20 4e 61 6d 65 | 20 6f 66 20 66 69 65 6c |ata Name| of fiel|
|000003e0| 64 20 66 6f 72 20 70 69 | 76 6f 74 20 74 61 62 6c |d for pi|vot tabl|
|000003f0| 65 20 64 61 74 61 2e 0d | 0a 6c 68 61 73 63 6f 6c |e data..|.lhascol|
|00000400| 75 6d 6e 74 6f 74 61 6c | 73 20 57 68 65 74 68 65 |umntotal|s Whethe|
|00000410| 72 20 74 6f 20 74 6f 74 | 61 6c 20 63 6f 6c 75 6d |r to tot|al colum|
|00000420| 6e 73 2e 0d 0a 6c 68 61 | 73 72 6f 77 74 6f 74 61 |ns...lha|srowtota|
|00000430| 6c 73 20 57 68 65 74 68 | 65 72 20 74 6f 20 74 6f |ls Wheth|er to to|
|00000440| 74 61 6c 20 72 6f 77 73 | 2e 0d 0a 6c 69 73 6e 75 |tal rows|...lisnu|
|00000450| 6d 65 72 69 63 0d 0a 6c | 68 61 73 6d 73 71 72 79 |meric..l|hasmsqry|
|00000460| 33 32 0d 0a 63 6f 75 74 | 66 69 6c 65 20 4e 61 6d |32..cout|file Nam|
|00000470| 65 20 6f 66 20 6f 75 74 | 70 75 74 20 66 69 6c 65 |e of out|put file|
|00000480| 2e 0d 0a 6c 68 61 73 6e | 6f 74 61 73 6b 0d 0a 2a |...lhasn|otask..*|
|00000490| 70 69 76 6f 74 6f 75 74 | 70 75 74 20 43 72 65 61 |pivotout|put Crea|
|000004a0| 74 65 20 45 78 63 65 6c | 20 70 69 76 6f 74 20 74 |te Excel| pivot t|
|000004b0| 61 62 6c 65 20 6f 75 74 | 70 75 74 2e 0d 0a 2a 67 |able out|put...*g|
|000004c0| 65 74 64 6f 73 6e 61 6d | 65 20 0d 0a 2a 6d 73 71 |etdosnam|e ..*msq|
|000004d0| 75 65 72 79 63 68 65 63 | 6b 20 51 75 65 72 79 20 |uerychec|k Query |
|000004e0| 66 6f 72 20 4d 53 20 51 | 75 65 72 79 2e 0d 0a 2a |for MS Q|uery...*|
|000004f0| 67 65 74 78 6c 70 61 74 | 68 20 43 68 65 63 6b 20 |getxlpat|h Check |
|00000500| 66 6f 72 20 45 78 63 65 | 6c 2e 0d 0a 2a 63 68 65 |for Exce|l...*che|
|00000510| 63 6b 66 6c 64 6c 65 6e | 20 0d 0a 5e 61 66 6c 64 |ckfldlen| ..^afld|
|00000520| 6c 69 73 74 5b 31 2c 31 | 5d 20 0d 0a 00 00 00 01 |list[1,1|] ......|
|00000530| 00 00 2c 5c fe f2 ff 20 | 02 01 00 00 00 43 2c 00 |..,\... |.....C,.|
|00000540| 00 43 2c 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |.C,.....|........|
|00000550| 00 00 00 00 00 00 00 00 | 00 00 00 13 21 08 00 00 |........|....!...|
|00000560| 00 25 00 00 00 e2 27 00 | 00 00 00 00 00 8a 2b 00 |.%....'.|......+.|
|00000570| 00 88 01 00 00 7a 28 00 | 00 00 00 00 00 00 00 00 |.....z(.|........|
|00000580| 00 fc 03 00 03 00 55 00 | 00 74 18 17 00 ae f7 00 |......U.|.t......|
|00000590| 00 07 f7 01 00 07 f7 02 | 00 07 f7 03 00 07 f7 04 |........|........|
|000005a0| 00 fe 1f 00 ae f7 05 00 | 07 f7 06 00 07 f7 07 00 |........|........|
|000005b0| 07 f7 08 00 07 f7 09 00 | 07 f7 0a 00 07 f7 0b 00 |........|........|
|000005c0| fe 13 00 ae f7 0c 00 07 | f7 0d 00 07 f7 0e 00 07 |........|........|
|000005d0| f7 0f 00 fe 0d 00 54 f5 | 0d f7 0a 00 10 fc 2d fd |......T.|......-.|
|000005e0| fe 0f 00 54 f5 0d f7 01 | 00 10 fc d9 00 00 fd fe |...T....|........|
|000005f0| 12 00 25 fc 43 f4 10 00 | f6 11 00 0a fd f9 05 7b |..%.C...|.......{|
|00000600| 00 fe 04 00 42 fe 04 00 | 1e fe 0d 00 46 fc f4 10 |....B...|....F...|
|00000610| 00 f7 12 00 03 fd fe 16 | 00 25 fc 43 43 f8 01 01 |........|.%.CC...|
|00000620| f4 10 00 f6 13 00 a1 fd | f9 05 c1 00 fe 10 00 15 |........|........|
|00000630| f4 10 00 f6 13 00 fc f8 | 01 01 fd 16 fe 0f 00 99 |........|........|
|00000640| fc 43 f4 10 00 e0 13 00 | ea 14 fd fe 04 00 1e fe |.C......|........|
|00000650| 10 00 25 fc 43 4e f8 01 | 00 10 fd f9 05 3a 01 fe |..%.CN..|.....:..|
|00000660| 61 00 99 fc 43 d9 51 00 | 54 68 65 20 74 61 62 6c |a...C.Q.|The tabl|
|00000670| 65 20 73 65 6c 65 63 74 | 65 64 20 63 6f 6e 74 61 |e select|ed conta|
|00000680| 69 6e 73 20 6e 6f 20 72 | 65 63 6f 72 64 73 2e 20 |ins no r|ecords. |
|00000690| 41 6e 20 45 78 63 65 6c | 20 70 69 76 6f 74 20 74 |An Excel| pivot t|
|000006a0| 61 62 6c 65 20 77 69 6c | 6c 20 6e 6f 74 20 62 65 |able wil|l not be|
|000006b0| 20 63 72 65 61 74 65 64 | 2e f4 10 00 f6 14 00 fd | created|........|
|000006c0| fe 04 00 42 fe 04 00 1e | fe 55 00 25 fc f4 10 00 |...B....|.U.%....|
|000006d0| f7 15 00 f8 01 02 14 f0 | 3e 00 43 f4 10 00 f7 16 |........|>.C.....|
|000006e0| 00 a1 f1 17 00 43 43 f4 | 10 00 f7 16 00 d9 03 00 |.....CC.|........|
|000006f0| 53 43 58 f4 10 00 f6 17 | 00 30 0a 0b f1 17 00 43 |SCX.....|.0.....C|
|00000700| 43 f4 10 00 f7 16 00 d9 | 03 00 53 43 54 f4 10 00 |C.......|..SCT...|
|00000710| f6 17 00 30 0a 0b 03 09 | fd f9 05 d2 01 fe 3b 00 |...0....|......;.|
|00000720| 99 fc 43 d9 2b 00 4e 6f | 20 66 6f 72 6d 20 66 69 |..C.+.No| form fi|
|00000730| 6c 65 20 73 70 65 63 69 | 66 69 65 64 2e 20 55 6e |le speci|fied. Un|
|00000740| 61 62 6c 65 20 74 6f 20 | 63 6f 6e 74 69 6e 75 65 |able to |continue|
|00000750| 2e f4 10 00 f6 14 00 fd | fe 04 00 42 fe 04 00 1e |........|...B....|
|00000760| fe 11 00 25 fc 43 4e f9 | 03 f4 01 11 fd f9 05 06 |...%.CN.|........|
|00000770| 04 fe 17 00 ae f7 18 00 | 07 f7 19 00 07 f7 1a 00 |........|........|
|00000780| 07 f7 1b 00 07 f7 1c 00 | fe 0d 00 15 f6 18 00 fc |........|........|
|00000790| f8 01 01 fd 16 fe 15 00 | 4a fc f8 01 01 fd 28 f7 |........|J.....(.|
|000007a0| 19 00 07 f7 1a 00 07 f7 | 1b 00 fe 0c 00 54 f7 1c |........|.....T..|
|000007b0| 00 10 fc 43 57 fd fe 13 | 00 25 fc 43 f4 10 00 f7 |...CW...|.%.C....|
|000007c0| 1d 00 a1 0a fd f9 05 67 | 02 fe 1a 00 6f be 15 fc |.......g|....o...|
|000007d0| 43 1b 03 fd fc 43 f4 10 | 00 f7 1d 00 ce fd bc 04 |C....C..|........|
|000007e0| f7 18 00 fe 0e 00 54 f5 | 0d f7 1b 00 10 fc ed 20 |......T.|....... |
|000007f0| fd fe 04 00 1e fe 14 00 | 25 fc f5 0d f7 1b 00 f9 |........|%.......|
|00000800| 03 2c 01 0d fd f9 05 14 | 03 fe 13 00 25 fc 43 f4 |.,......|....%.C.|
|00000810| 10 00 f7 1f 00 a1 0a fd | f9 05 ba 02 fe 1a 00 6f |........|.......o|
|00000820| be 15 fc 43 1b 03 fd fc | 43 f4 10 00 f7 1f 00 ce |...C....|C.......|
|00000830| fd bc 04 f7 18 00 fe 0e | 00 54 f5 0d f7 1a 00 10 |........|.T......|
|00000840| fc ed 20 fd fe 04 00 1e | fe 13 00 25 fc f5 0d f7 |.. .....|...%....|
|00000850| 1a 00 f8 03 64 0d fd f9 | 05 10 03 fe 13 00 25 fc |....d...|......%.|
|00000860| 43 f4 10 00 f7 20 00 a1 | 0a fd f9 05 0c 03 fe 1a |C.... ..|........|
|00000870| 00 6f be 15 fc 43 1b 03 | fd fc 43 f4 10 00 f7 20 |.o...C..|..C.... |
|00000880| 00 ce fd bc 04 f7 18 00 | fe 0e 00 54 f5 0d f7 19 |........|...T....|
|00000890| 00 10 fc ed 20 fd fe 04 | 00 1e fe 04 00 1e fe 04 |.... ...|........|
|000008a0| 00 1e fe 12 00 25 fc 43 | 57 f5 0d f7 1c 00 0f fd |.....%.C|W.......|
|000008b0| f9 05 36 03 fe 0c 00 46 | fc f5 0d f7 1c 00 03 fd |..6....F|........|
|000008c0| fe 04 00 1e fe 48 00 25 | fc f5 0d f7 1b 00 f9 03 |.....H.%|........|
|000008d0| 2c 01 12 f1 0a 00 f5 0d | f7 1a 00 f8 03 64 12 0b |,.......|.....d..|
|000008e0| f1 0a 00 f5 0d f7 19 00 | f8 03 64 12 0b f1 17 00 |........|..d.....|
|000008f0| f5 0d f7 1b 00 f5 0d f7 | 1a 00 04 f5 0d f7 19 00 |........|........|
|00000900| 04 f9 05 10 27 11 0b fd | f9 05 02 04 fe 78 00 25 |....'...|.....x.%|
|00000910| fc 43 d9 3e 00 59 6f 75 | 20 68 61 76 65 20 73 65 |.C.>.You| have se|
|00000920| 6c 65 63 74 65 64 20 61 | 20 70 6f 74 65 6e 74 69 |lected a| potenti|
|00000930| 61 6c 6c 79 20 6c 61 72 | 67 65 20 70 69 76 6f 74 |ally lar|ge pivot|
|00000940| 20 74 61 62 6c 65 20 72 | 65 73 75 6c 74 20 73 65 | table r|esult se|
|00000950| 74 2e 20 d9 18 00 44 6f | 20 79 6f 75 20 77 61 6e |t. ...Do| you wan|
|00000960| 74 20 74 6f 20 63 6f 6e | 74 69 6e 75 65 3f 06 f8 |t to con|tinue?..|
|00000970| 02 24 f4 10 00 f6 14 00 | d9 03 00 59 45 53 0f fd |.$......|...YES..|
|00000980| f9 05 fe 03 fe 04 00 42 | fe 04 00 1e fe 04 00 1e |.......B|........|
|00000990| fe 04 00 1e fe 1e 00 25 | fc 43 fb 0a 00 73 6f 75 |.......%|.C...sou|
|000009a0| 72 63 65 74 79 70 65 ea | 89 f8 01 03 10 fd f9 05 |rcetype.|........|
|000009b0| 41 06 fe 14 00 54 f7 0c | 00 10 fc 43 43 26 61 f4 |A....T..|...CC&a.|
|000009c0| 10 00 f6 21 00 fd fe 38 | 00 25 fc f5 0d f7 0c 00 |...!...8|.%......|
|000009d0| 43 26 0f f1 10 00 43 43 | 43 26 f4 10 00 f6 22 00 |C&....CC|C&....".|
|000009e0| 3e f8 02 0c 11 0b f1 10 | 00 43 43 43 26 f4 10 00 |>.......|.CCC&...|
|000009f0| f6 23 00 3e f8 01 08 11 | 0b fd f9 05 3d 06 fe 11 |.#.>....|....=...|
|00000a00| 00 25 fc f4 10 00 f7 24 | 00 0a fd f9 05 39 06 fe |.%.....$|.....9..|
|00000a10| 99 01 25 fc 43 d9 85 00 | 59 6f 75 20 68 61 76 65 |..%.C...|You have|
|00000a20| 20 61 6e 20 6f 6c 64 20 | 46 6f 78 50 72 6f 20 4f | an old |FoxPro O|
|00000a30| 44 42 43 20 44 61 74 61 | 20 53 6f 75 72 63 65 20 |DBC Data| Source |
|00000a40| 69 6e 73 74 61 6c 6c 65 | 64 20 77 68 69 63 68 20 |installe|d which |
|00000a50| 64 6f 65 73 20 6e 6f 74 | 20 73 75 70 70 6f 72 74 |does not| support|
|00000a60| 20 46 6f 78 50 72 6f 20 | 74 61 62 6c 65 73 20 77 | FoxPro |tables w|
|00000a70| 69 74 68 20 6c 6f 6e 67 | 20 6f 72 20 69 6c 6c 65 |ith long| or ille|
|00000a80| 67 61 6c 20 44 4f 53 20 | 70 61 74 68 20 61 6e 64 |gal DOS |path and|
|00000a90| 20 66 69 6c 65 20 6e 61 | 6d 65 73 2e 20 d9 57 00 | file na|mes. .W.|
|00000aa0| 57 65 20 73 75 67 67 65 | 73 74 20 74 68 61 74 20 |We sugge|st that |
|00000ab0| 79 6f 75 20 69 6e 73 74 | 61 6c 6c 20 74 68 65 20 |you inst|all the |
|00000ac0| 56 46 50 20 4f 44 42 43 | 20 44 72 69 76 65 72 20 |VFP ODBC| Driver |
|00000ad0| 74 6f 20 70 72 65 76 65 | 6e 74 20 74 68 69 73 20 |to preve|nt this |
|00000ae0| 6d 65 73 73 61 67 65 20 | 69 6e 20 74 68 65 20 66 |message |in the f|
|00000af0| 75 74 75 72 65 2e 20 06 | d9 97 00 49 66 20 79 6f |uture. .|...If yo|
|00000b00| 75 20 63 68 6f 6f 73 65 | 20 74 6f 20 63 6f 6e 74 |u choose| to cont|
|00000b10| 69 6e 75 65 2c 20 79 6f | 75 20 6d 75 73 74 20 65 |inue, yo|u must e|
|00000b20| 69 74 68 65 72 20 72 65 | 6e 61 6d 65 20 6f 72 20 |ither re|name or |
|00000b30| 63 6f 70 79 20 74 68 65 | 20 73 65 6c 65 63 74 65 |copy the| selecte|
|00000b40| 64 20 74 61 62 6c 65 20 | 74 6f 20 6f 6e 65 20 77 |d table |to one w|
|00000b50| 69 74 68 20 61 20 73 74 | 61 6e 64 61 72 64 20 44 |ith a st|andard D|
|00000b60| 4f 53 20 66 69 6c 65 20 | 6e 61 6d 65 2e 20 57 6f |OS file |name. Wo|
|00000b70| 75 6c 64 20 79 6f 75 20 | 6c 69 6b 65 20 74 6f 20 |uld you |like to |
|00000b80| 63 6f 70 79 20 74 68 65 | 20 66 69 6c 65 20 6e 6f |copy the| file no|
|00000b90| 77 3f 06 f8 02 24 f4 10 | 00 f6 14 00 d9 03 00 59 |w?...$..|.......Y|
|00000ba0| 45 53 10 fd f9 05 29 06 | fe 0b 00 54 f7 0a 00 10 |ES....).|...T....|
|00000bb0| fc 61 fd fe 08 00 1b f9 | 05 35 06 fe 04 00 42 fe |.a......|.5....B.|
|00000bc0| 04 00 1e fe 04 00 1e fe | 04 00 1e fe 04 00 1e fe |........|........|
|00000bd0| 1a 00 54 f4 10 00 f7 25 | 00 10 fc 43 f4 10 00 f7 |..T....%|...C....|
|00000be0| 27 00 f4 10 00 f6 26 00 | fd fe 2d 00 25 fc f4 10 |'.....&.|..-.%...|
|00000bf0| 00 f7 28 00 f0 0a 00 43 | f4 10 00 f7 25 00 a1 0a |..(....C|....%...|
|00000c00| 09 f0 0d 00 43 f4 10 00 | f7 25 00 f8 01 02 ea a2 |....C...|.%......|
|00000c10| 09 fd f9 05 a5 07 fe bf | 00 25 fc 43 d9 3e 00 45 |........|.%.C.>.E|
|00000c20| 78 63 65 6c 20 63 61 6e | 6e 6f 74 20 63 72 65 61 |xcel can|not crea|
|00000c30| 74 65 20 61 20 70 69 76 | 6f 74 20 74 61 62 6c 65 |te a piv|ot table|
|00000c40| 20 66 72 6f 6d 20 74 68 | 65 20 73 65 6c 65 63 74 | from th|e select|
|00000c50| 65 64 20 64 61 74 61 62 | 61 73 65 20 27 f4 10 00 |ed datab|ase '...|
|00000c60| f7 25 00 06 d9 5f 00 27 | 20 75 6e 6c 65 73 73 20 |.%..._.'| unless |
|00000c70| 69 74 20 69 73 20 6f 70 | 65 6e 65 64 20 73 68 61 |it is op|ened sha|
|00000c80| 72 65 64 2e 20 57 6f 75 | 6c 64 20 79 6f 75 20 6c |red. Wou|ld you l|
|00000c90| 69 6b 65 20 74 68 65 20 | 50 69 76 6f 74 54 61 62 |ike the |PivotTab|
|00000ca0| 6c 65 20 57 69 7a 61 72 | 64 20 74 6f 20 72 65 6f |le Wizar|d to reo|
|00000cb0| 70 65 6e 20 69 74 20 73 | 68 61 72 65 64 20 66 6f |pen it s|hared fo|
|00000cc0| 72 20 79 6f 75 3f 06 f8 | 02 24 ea 78 f8 01 06 14 |r you?..|.$.x....|
|00000cd0| fd f9 05 95 07 fe 10 00 | 54 f7 29 00 10 fc f4 10 |........|T.).....|
|00000ce0| 00 f7 25 00 fd fe 0e 00 | 47 7f 28 fc f5 0d f7 29 |..%.....|G.(....)|
|00000cf0| 00 03 fd fe 05 00 0f c2 | fe 0f 00 95 c2 fc f4 10 |........|........|
|00000d00| 00 f7 27 00 03 fd c2 fe | 18 00 51 c2 fc f4 10 00 |..'.....|..Q.....|
|00000d10| f7 2a 00 03 fd 02 fc f4 | 10 00 f7 12 00 03 fd fe |.*......|........|
|00000d20| 08 00 1b f9 05 a1 07 fe | 04 00 42 fe 04 00 1e fe |........|..B.....|
|00000d30| 04 00 1e fe 44 00 25 fc | f5 0d f7 0a 00 0a f0 08 |....D.%.|........|
|00000d40| 00 f4 10 00 f7 28 00 0a | 09 f0 26 00 43 43 f9 04 |.....(..|..&.CC..|
|00000d50| ed 07 5d 67 f7 2b 00 10 | f1 15 00 43 fb 0a 00 73 |..]g.+..|...C...s|
|00000d60| 6f 75 72 63 65 74 79 70 | 65 ea 89 f8 01 03 0f 0b |ourcetyp|e.......|
|00000d70| 03 09 fd f9 05 27 08 fe | 1f 00 25 fc 43 00 f7 2c |.....'..|..%.C..,|
|00000d80| 00 f8 02 24 f4 10 00 f6 | 14 00 d9 03 00 59 45 53 |...$....|.....YES|
|00000d90| 10 fd f9 05 17 08 fe 0b | 00 54 f7 0a 00 10 fc 61 |........|.T.....a|
|00000da0| fd fe 08 00 1b f9 05 23 | 08 fe 04 00 42 fe 04 00 |.......#|....B...|
|00000db0| 1e fe 04 00 1e fe 0f 00 | 25 fc f5 0d f7 0a 00 fd |........|%.......|
|00000dc0| f9 05 c1 0c fe 09 00 ae | f5 0d f7 2d 00 fe 1e 00 |........|...-....|
|00000dd0| 25 fc 43 fb 0a 00 73 6f | 75 72 63 65 74 79 70 65 |%.C...so|urcetype|
|00000de0| ea 89 f8 01 03 0f fd f9 | 05 7b 08 fe 1a 00 54 f7 |........|.{....T.|
|00000df0| 2d 00 10 fc 43 d9 0a 00 | 73 6f 75 72 63 65 6e 61 |-...C...|sourcena|
|00000e00| 6d 65 ea 89 fd fe 08 00 | 1b f9 05 96 08 fe 13 00 |me......|........|
|00000e10| 54 f7 2d 00 10 fc 43 43 | 26 f4 10 00 f6 23 00 fd |T.-...CC|&....#..|
|00000e20| fe 04 00 1e fe 0d 00 18 | 48 f9 05 a7 08 f9 05 32 |........|H......2|
|00000e30| 09 fe 15 00 0c fc 43 f5 | 0d f7 2d 00 3e f8 01 08 |......C.|..-.>...|
|00000e40| 0d fd f9 05 d0 08 fe 14 | 00 54 f7 2d 00 10 fc f5 |........|.T.-....|
|00000e50| 0d f7 2d 00 d9 01 00 32 | 06 fd fe 28 00 0c fc 43 |..-....2|...(...C|
|00000e60| f5 0d f7 2d 00 3e f8 01 | 08 10 f0 10 00 43 f5 0d |...-.>..|.....C..|
|00000e70| f7 2d 00 f8 01 01 52 d9 | 01 00 32 10 09 fd f9 05 |.-....R.|..2.....|
|00000e80| 11 09 fe 19 00 54 f7 2d | 00 10 fc 43 f5 0d f7 2d |.....T.-|...C...-|
|00000e90| 00 f8 01 07 3d d9 01 00 | 5f 06 fd fe 08 00 32 f9 |....=...|_.....2.|
|00000ea0| 05 32 09 fe 19 00 54 f7 | 2d 00 10 fc 43 f5 0d f7 |.2....T.|-...C...|
|00000eb0| 2d 00 f8 01 07 3d d9 01 | 00 32 06 fd fe 04 00 1c |-....=..|.2......|
|00000ec0| fe 17 00 54 f7 2d 00 10 | fc 43 00 f5 0d f7 2d 00 |...T.-..|.C....-.|
|00000ed0| f4 10 00 f6 21 00 fd fe | 0c 00 18 2b fc 61 fd f9 |....!...|...+.a..|
|00000ee0| 05 e2 0b fe 30 00 54 f7 | 2d 00 10 fc 43 d9 0e 00 |....0.T.|-...C...|
|00000ef0| 43 6f 70 79 20 74 61 62 | 6c 65 20 74 6f 3a f5 0d |Copy tab|le to:..|
|00000f00| f7 2d 00 d9 04 00 2e 64 | 62 66 06 d9 03 00 44 42 |.-.....d|bf....DB|
|00000f10| 46 c2 fd fe 11 00 25 fc | 43 f5 0d f7 2d 00 a1 fd |F.....%.|C...-...|
|00000f20| f9 05 9e 09 fe 04 00 42 | fe 04 00 1e fe 1d 00 54 |.......B|.......T|
|00000f30| f7 2d 00 10 fc 43 00 f5 | 0d f7 2d 00 d9 03 00 44 |.-...C..|..-....D|
|00000f40| 42 46 f4 10 00 f6 17 00 | fd fe 18 00 54 f7 0c 00 |BF......|....T...|
|00000f50| 10 fc 43 00 f5 0d f7 2d | 00 61 f4 10 00 f6 21 00 |..C....-|.a....!.|
|00000f60| fd fe 43 00 25 fc f5 0d | f7 0c 00 f5 0d f7 2d 00 |..C.%...|......-.|
|00000f70| 0f f1 14 00 43 43 00 f5 | 0d f7 2d 00 f4 10 00 f6 |....CC..|..-.....|
|00000f80| 22 00 3e f8 02 0c 11 0b | f1 14 00 43 43 00 f5 0d |".>.....|...CC...|
|00000f90| f7 2d 00 f4 10 00 f6 23 | 00 3e f8 01 08 11 0b fd |.-.....#|.>......|
|00000fa0| f9 05 d2 0b fe 99 01 25 | fc 43 d9 85 00 59 6f 75 |.......%|.C...You|
|00000fb0| 20 68 61 76 65 20 61 6e | 20 6f 6c 64 20 46 6f 78 | have an| old Fox|
|00000fc0| 50 72 6f 20 4f 44 42 43 | 20 44 61 74 61 20 53 6f |Pro ODBC| Data So|
|00000fd0| 75 72 63 65 20 69 6e 73 | 74 61 6c 6c 65 64 20 77 |urce ins|talled w|
|00000fe0| 68 69 63 68 20 64 6f 65 | 73 20 6e 6f 74 20 73 75 |hich doe|s not su|
|00000ff0| 70 70 6f 72 74 20 46 6f | 78 50 72 6f 20 74 61 62 |pport Fo|xPro tab|
|00001000| 6c 65 73 20 77 69 74 68 | 20 6c 6f 6e 67 20 6f 72 |les with| long or|
|00001010| 20 69 6c 6c 65 67 61 6c | 20 44 4f 53 20 70 61 74 | illegal| DOS pat|
|00001020| 68 20 61 6e 64 20 66 69 | 6c 65 20 6e 61 6d 65 73 |h and fi|le names|
|00001030| 2e 20 d9 57 00 57 65 20 | 73 75 67 67 65 73 74 20 |. .W.We |suggest |
|00001040| 74 68 61 74 20 79 6f 75 | 20 69 6e 73 74 61 6c 6c |that you| install|
|00001050| 20 74 68 65 20 56 46 50 | 20 4f 44 42 43 20 44 72 | the VFP| ODBC Dr|
|00001060| 69 76 65 72 20 74 6f 20 | 70 72 65 76 65 6e 74 20 |iver to |prevent |
|00001070| 74 68 69 73 20 6d 65 73 | 73 61 67 65 20 69 6e 20 |this mes|sage in |
|00001080| 74 68 65 20 66 75 74 75 | 72 65 2e 20 06 d9 97 00 |the futu|re. ....|
|00001090| 49 66 20 79 6f 75 20 63 | 68 6f 6f 73 65 20 74 6f |If you c|hoose to|
|000010a0| 20 63 6f 6e 74 69 6e 75 | 65 2c 20 79 6f 75 20 6d | continu|e, you m|
|000010b0| 75 73 74 20 65 69 74 68 | 65 72 20 72 65 6e 61 6d |ust eith|er renam|
|000010c0| 65 20 6f 72 20 63 6f 70 | 79 20 74 68 65 20 73 65 |e or cop|y the se|
|000010d0| 6c 65 63 74 65 64 20 74 | 61 62 6c 65 20 74 6f 20 |lected t|able to |
|000010e0| 6f 6e 65 20 77 69 74 68 | 20 61 20 73 74 61 6e 64 |one with| a stand|
|000010f0| 61 72 64 20 44 4f 53 20 | 66 69 6c 65 20 6e 61 6d |ard DOS |file nam|
|00001100| 65 2e 20 57 6f 75 6c 64 | 20 79 6f 75 20 6c 69 6b |e. Would| you lik|
|00001110| 65 20 74 6f 20 63 6f 70 | 79 20 74 68 65 20 66 69 |e to cop|y the fi|
|00001120| 6c 65 20 6e 6f 77 3f 06 | f8 02 24 f4 10 00 f6 14 |le now?.|..$.....|
|00001130| 00 d9 03 00 59 45 53 0f | fd f9 05 b7 0b fe 04 00 |....YES.|........|
|00001140| 42 fe 04 00 1e fe 17 00 | 54 f7 2d 00 10 fc 43 00 |B.......|T.-...C.|
|00001150| f5 0d f7 2d 00 f4 10 00 | f6 23 00 fd fe 08 00 1b |...-....|.#......|
|00001160| f9 05 de 0b fe 04 00 21 | fe 04 00 1e fe 04 00 1d |.......!|........|
|00001170| fe 0f 00 11 28 fc f5 0d | f7 2d 00 03 fd d4 ce fe |....(...|.-......|
|00001180| 12 00 25 fc 43 f5 0d f7 | 2d 00 30 0a fd f9 05 0b |..%.C...|-.0.....|
|00001190| 0c fe 04 00 42 fe 04 00 | 1e fe 08 00 46 f9 01 00 |....B...|....F...|
|000011a0| 00 fe 0d 00 51 c2 fc f5 | 0d f7 2d 00 03 fd fe 1e |....Q...|..-.....|
|000011b0| 00 25 fc 43 43 1b a1 f1 | 0d 00 43 43 f9 04 ed 07 |.%.CC...|..CC....|
|000011c0| 5d 67 f7 2b 00 10 0b fd | f9 05 46 0c fe 04 00 42 |]g.+....|..F....B|
|000011d0| fe 04 00 1e fe 0f 00 54 | f4 10 00 f7 12 00 10 fc |.......T|........|
|000011e0| 43 1b fd fe 1a 00 54 f4 | 10 00 f7 2e 00 10 fc 43 |C.....T.|.......C|
|000011f0| f4 10 00 f7 2e 00 f4 10 | 00 f6 2f 00 fd fe 1a 00 |........|../.....|
|00001200| 54 f4 10 00 f7 20 00 10 | fc 43 f4 10 00 f7 20 00 |T.... ..|.C.... .|
|00001210| f4 10 00 f6 2f 00 fd fe | 1a 00 54 f4 10 00 f7 1d |..../...|..T.....|
|00001220| 00 10 fc 43 f4 10 00 f7 | 1d 00 f4 10 00 f6 2f 00 |...C....|....../.|
|00001230| fd fe 1a 00 54 f4 10 00 | f7 1f 00 10 fc 43 f4 10 |....T...|.....C..|
|00001240| 00 f7 1f 00 f4 10 00 f6 | 2f 00 fd fe 04 00 1e fe |........|/.......|
|00001250| 25 00 25 fc 43 ea a2 f0 | 15 00 43 fb 0a 00 73 6f |%.%.C...|..C...so|
|00001260| 75 72 63 65 74 79 70 65 | ea 89 f8 01 03 14 09 fd |urcetype|........|
|00001270| f9 05 34 0d fe 0e 00 54 | f5 0d f7 08 00 10 fc 43 |..4....T|.......C|
|00001280| 26 fd fe 0d 00 51 c2 fc | f5 0d f7 08 00 03 fd fe |&....Q..|........|
|00001290| 18 00 25 fc 43 43 1b a1 | f1 07 00 f4 10 00 f7 30 |..%.CC..|.......0|
|000012a0| 00 0b fd f9 05 21 0d fe | 04 00 42 fe 04 00 1e fe |.....!..|..B.....|
|000012b0| 0f 00 54 f4 10 00 f7 12 | 00 10 fc 43 1b fd fe 04 |..T.....|...C....|
|000012c0| 00 1e fe 18 00 54 f5 0d | f7 0b 00 10 fc 43 d9 06 |.....T..|.....C..|
|000012d0| 00 53 41 46 45 54 59 ea | 35 fd fe 13 00 86 fc 43 |.SAFETY.|5......C|
|000012e0| d9 06 00 53 41 46 45 54 | 59 2d ea 35 fd fe 20 00 |...SAFET|Y-.5.. .|
|000012f0| 54 f5 0d f7 0d 00 10 fc | 43 d9 05 00 45 78 63 65 |T.......|C...Exce|
|00001300| 6c d9 06 00 53 79 73 74 | 65 6d ea 2c fd fe 14 00 |l...Syst|em.,....|
|00001310| 25 fc f5 0d f7 0d 00 f9 | 02 ff ff 10 fd f9 05 e3 |%.......|........|
|00001320| 0d fe 2b 00 99 fc 43 d9 | 1b 00 53 74 61 72 74 69 |..+...C.|..Starti|
|00001330| 6e 67 20 4d 69 63 72 6f | 73 6f 66 74 20 45 78 63 |ng Micro|soft Exc|
|00001340| 65 6c 2e 2e 2e f4 10 00 | f6 31 00 fd fe 21 00 54 |el......|.1...!.T|
|00001350| f7 05 00 10 fc 43 d9 11 | 00 65 78 63 65 6c 2e 61 |.....C..|.excel.a|
|00001360| 70 70 6c 69 63 61 74 69 | 6f 6e ea 4e fd fe 08 00 |pplicati|on.N....|
|00001370| 1b f9 05 1b 0e fe 0e 00 | 86 fc 43 f5 0d f7 0d 00 |........|..C.....|
|00001380| ea 31 fd fe 22 00 54 f7 | 05 00 10 fc 43 db d9 11 |.1..".T.|....C...|
|00001390| 00 65 78 63 65 6c 2e 61 | 70 70 6c 69 63 61 74 69 |.excel.a|pplicati|
|000013a0| 6f 6e ea 5c fd fe 04 00 | 1e fe 17 00 86 fc 43 d9 |on.\....|......C.|
|000013b0| 06 00 53 41 46 45 54 59 | f5 0d f7 0b 00 ea 35 fd |..SAFETY|......5.|
|000013c0| fe 10 00 99 fc 43 f9 04 | be 0b f9 04 09 04 5d fd |.....C..|......].|
|000013d0| fe 23 00 25 fc 43 fb 05 | 00 78 6c 61 70 70 62 fb |.#.%.C..|.xlappb.|
|000013e0| 01 00 4f 0f f1 07 00 f4 | 10 00 f7 30 00 0b fd f9 |..O.....|...0....|
|000013f0| 05 98 0e fe 2b 00 99 fc | 43 d9 1f 00 46 61 69 6c |....+...|C...Fail|
|00001400| 65 64 20 74 6f 20 67 65 | 74 20 45 78 63 65 6c 20 |ed to ge|t Excel |
|00001410| 4f 4c 45 20 4f 62 6a 65 | 63 74 2e ea 78 fd fe 04 |OLE Obje|ct..x...|
|00001420| 00 42 fe 08 00 1b f9 05 | e0 0e fe 0e 00 54 f4 10 |.B......|.....T..|
|00001430| 00 f7 32 00 10 fc 61 fd | fe 0c 00 86 fc f4 05 00 |..2...a.|........|
|00001440| f7 33 00 fd fe 10 00 25 | fc f4 10 00 f7 30 00 fd |.3.....%|.....0..|
|00001450| f9 05 ce 0e fe 04 00 42 | fe 04 00 1e fe 0e 00 54 |.......B|.......T|
|00001460| f4 10 00 f7 32 00 10 fc | 2d fd fe 04 00 1e fe 0d |....2...|-.......|
|00001470| 00 18 48 f9 05 f1 0e f9 | 05 4d 10 fe 14 00 0c fc |..H.....|.M......|
|00001480| f4 10 00 f7 15 00 f8 01 | 01 10 fd f9 05 30 0f fe |........|.....0..|
|00001490| 0e 00 54 f4 05 00 f7 34 | 00 10 fc 61 fd fe 0d 00 |..T....4|...a....|
|000014a0| 99 f4 05 00 f4 35 00 f7 | 36 00 fe 10 00 54 f7 06 |.....5..|6....T..|
|000014b0| 00 10 fc f4 05 00 f7 37 | 00 fd fe 14 00 0c fc f4 |.......7|........|
|000014c0| 10 00 f7 15 00 f8 01 02 | 10 fd f9 05 4d 10 fe 0b |........|....M...|
|000014d0| 00 ae f7 16 00 07 f7 38 | 00 fe 10 00 54 f7 16 00 |.......8|....T...|
|000014e0| 10 fc f4 10 00 f7 16 00 | fd fe 38 00 25 fc f5 0d |........|..8.%...|
|000014f0| f7 0d 00 f9 02 ff ff 0f | f0 10 00 43 d9 05 00 78 |........|...C...x|
|00001500| 6c 61 70 70 62 d9 01 00 | 4f 10 09 f0 0e 00 f4 05 |lappb...|O.......|
|00001510| 00 f4 35 00 f7 39 00 f8 | 01 00 10 09 fd f9 05 a4 |..5..9..|........|
|00001520| 0f fe 0d 00 99 f4 05 00 | f4 35 00 f7 36 00 fe 04 |........|.5..6...|
|00001530| 00 1e fe 2f 00 01 44 4f | 20 46 4f 52 4d 20 22 26 |.../..DO| FORM "&|
|00001540| 63 46 6f 72 6d 53 43 58 | 22 20 4e 41 4d 45 20 78 |cFormSCX|" NAME x|
|00001550| 6c 70 69 76 6f 74 66 6f | 72 6d 20 4c 49 4e 4b 45 |lpivotfo|rm LINKE|
|00001560| 44 0a 16 00 54 f7 05 00 | 10 fc f4 3a 00 f4 3b 00 |D...T...|...:..;.|
|00001570| f4 3c 00 f7 3d 00 fd fe | 14 00 25 fc f5 0d f7 0d |.<..=...|..%.....|
|00001580| 00 f9 02 ff ff 0f fd f9 | 05 1e 10 fe 1d 00 54 f7 |........|......T.|
|00001590| 06 00 10 fc 43 f8 01 01 | f4 3a 00 f4 3b 00 f4 3c |....C...|.:..;..<|
|000015a0| 00 f4 3e 00 f6 3f 00 fd | fe 08 00 1b f9 05 49 10 |..>..?..|......I.|
|000015b0| fe 13 00 99 f4 05 00 e5 | 40 00 fc f8 01 01 fd 03 |........|@.......|
|000015c0| f7 41 00 fe 10 00 54 f7 | 06 00 10 fc f4 05 00 f7 |.A....T.|........|
|000015d0| 37 00 fd fe 04 00 1e fe | 04 00 1c fe 10 00 25 fc |7.......|......%.|
|000015e0| f4 10 00 f7 30 00 fd f9 | 05 65 10 fe 04 00 42 fe |....0...|.e....B.|
|000015f0| 04 00 1e fe 4d 00 99 fc | 43 d9 3d 00 50 6c 65 61 |....M...|C.=.Plea|
|00001600| 73 65 20 62 65 20 70 61 | 74 69 65 6e 74 20 77 68 |se be pa|tient wh|
|00001610| 69 6c 65 20 74 68 65 20 | 70 69 76 6f 74 20 74 61 |ile the |pivot ta|
|00001620| 62 6c 65 20 69 73 20 62 | 65 69 6e 67 20 67 65 6e |ble is b|eing gen|
|00001630| 65 72 61 74 65 64 2e 2e | 2e f4 10 00 f6 31 00 fd |erated..|.....1..|
|00001640| fe 0d 00 46 fc f4 10 00 | f7 12 00 03 fd fe 1a 00 |...F....|........|
|00001650| 54 f5 0d f7 00 00 10 fc | 43 43 d9 07 00 44 45 46 |T.......|CC...DEF|
|00001660| 41 55 4c 54 76 bb fd fe | 19 00 25 fc 43 f5 0d f7 |AULTv...|..%.C...|
|00001670| 00 00 f8 01 01 52 d9 01 | 00 5c 10 fd f9 05 14 11 |.....R..|.\......|
|00001680| fe 1e 00 54 f5 0d f7 00 | 00 10 fc 43 f5 0d f7 00 |...T....|...C....|
|00001690| 00 43 f5 0d f7 00 00 3e | f8 01 01 08 3d fd fe 04 |.C.....>|....=...|
|000016a0| 00 1e fe 26 00 54 f7 09 | 00 10 fc d9 01 00 60 43 |...&.T..|......`C|
|000016b0| 43 d9 0a 00 73 6f 75 72 | 63 65 6e 61 6d 65 ea 89 |C...sour|cename..|
|000016c0| 40 06 d9 01 00 60 06 fd | fe 0f 00 54 f5 0d f7 01 |@....`..|...T....|
|000016d0| 00 10 fc d9 00 00 fd fe | 0d 00 18 48 f9 05 5a 11 |........|...H..Z.|
|000016e0| f9 05 58 13 fe 1e 00 0c | fc 43 fb 0a 00 73 6f 75 |..X.....|.C...sou|
|000016f0| 72 63 65 74 79 70 65 ea | 89 f8 01 03 0f fd f9 05 |rcetype.|........|
|00001700| 57 12 fe 1c 00 84 f7 03 | 00 10 fc f8 01 01 fd 28 |W.......|.......(|
|00001710| fc 43 f4 10 00 e0 42 00 | cd fd f9 05 f7 11 fe 2c |.C....B.|.......,|
|00001720| 00 54 f5 0d f7 01 00 10 | fc f5 0d f7 01 00 f5 0d |.T......|........|
|00001730| f7 09 00 06 d9 01 00 2e | 06 43 43 00 f5 0d f7 03 |........|.CC.....|
|00001740| 00 f4 10 00 f6 42 00 40 | 06 fd fe 18 00 25 fc f5 |.....B.@|.....%..|
|00001750| 0d f7 03 00 43 f4 10 00 | e0 42 00 cd 10 fd f9 05 |....C...|.B......|
|00001760| dc 11 fe 04 00 21 fe 04 | 00 1e fe 17 00 54 f5 0d |.....!..|.....T..|
|00001770| f7 01 00 10 fc f5 0d f7 | 01 00 d9 02 00 2c 20 06 |........|....., .|
|00001780| fd fe 04 00 85 fe 26 00 | 54 f5 0d f7 01 00 10 fc |......&.|T.......|
|00001790| d9 07 00 53 45 4c 45 43 | 54 20 f5 0d f7 01 00 06 |...SELEC|T ......|
|000017a0| d9 06 00 20 46 52 4f 4d | 20 06 fd fe 15 00 25 fc |... FROM| .....%.|
|000017b0| 43 f5 0d f7 01 00 3e f8 | 03 e6 11 fd f9 05 53 12 |C.....>.|......S.|
|000017c0| fe 1d 00 54 f5 0d f7 01 | 00 10 fc d9 0e 00 53 45 |...T....|......SE|
|000017d0| 4c 45 43 54 20 2a 20 46 | 52 4f 4d 20 fd fe 04 00 |LECT * F|ROM ....|
|000017e0| 1e fe 0b 00 0c fc 2d fd | f9 05 7f 12 fe 1d 00 54 |......-.|.......T|
|000017f0| f5 0d f7 01 00 10 fc d9 | 0e 00 53 45 4c 45 43 54 |........|..SELECT|
|00001800| 20 2a 20 46 52 4f 4d 20 | fd fe 08 00 32 f9 05 58 | * FROM |....2..X|
|00001810| 13 fe 1c 00 84 f7 03 00 | 10 fc f8 01 01 fd 28 fc |........|......(.|
|00001820| 43 f4 10 00 e0 42 00 cd | fd f9 05 f8 12 fe 1f 00 |C....B..|........|
|00001830| 54 f5 0d f7 01 00 10 fc | f5 0d f7 01 00 43 00 f5 |T.......|.....C..|
|00001840| 0d f7 03 00 f4 10 00 f6 | 42 00 06 fd fe 18 00 25 |........|B......%|
|00001850| fc f5 0d f7 03 00 43 f4 | 10 00 e0 42 00 cd 10 fd |......C.|...B....|
|00001860| f9 05 de 12 fe 04 00 21 | fe 04 00 1e fe 16 00 54 |.......!|.......T|
|00001870| f5 0d f7 01 00 10 fc f5 | 0d f7 01 00 d9 01 00 2c |........|.......,|
|00001880| 06 fd fe 04 00 85 fe 26 | 00 54 f5 0d f7 01 00 10 |.......&|.T......|
|00001890| fc d9 07 00 53 45 4c 45 | 43 54 20 f5 0d f7 01 00 |....SELE|CT .....|
|000018a0| 06 d9 06 00 20 46 52 4f | 4d 20 06 fd fe 15 00 25 |.... FRO|M .....%|
|000018b0| fc 43 f5 0d f7 01 00 3e | f8 03 e6 11 fd f9 05 54 |.C.....>|.......T|
|000018c0| 13 fe 1d 00 54 f5 0d f7 | 01 00 10 fc d9 0e 00 53 |....T...|.......S|
|000018d0| 45 4c 45 43 54 20 2a 20 | 46 52 4f 4d 20 fd fe 04 |ELECT * |FROM ...|
|000018e0| 00 1e fe 04 00 1c fe 0d | 00 15 f6 02 00 fc f8 01 |........|........|
|000018f0| 02 fd 16 fe 9f 00 54 f6 | 02 00 fc f8 01 01 fd 16 |......T.|........|
|00001900| 10 fc d9 04 00 44 53 4e | 3d f4 10 00 f7 43 00 06 |.....DSN|=....C..|
|00001910| d9 0a 00 3b 53 6f 75 72 | 63 65 44 42 3d 06 43 43 |...;Sour|ceDB=.CC|
|00001920| f4 10 00 f7 27 00 a1 f2 | 08 00 f5 0d f7 00 00 f3 |....'...|........|
|00001930| 06 00 f4 10 00 f7 27 00 | 36 06 d9 0c 00 3b 53 6f |......'.|6....;So|
|00001940| 75 72 63 65 54 79 70 65 | 3d 06 43 43 f4 10 00 f7 |urceType|=.CC....|
|00001950| 27 00 a1 f2 09 00 d9 03 | 00 44 42 46 f3 06 00 d9 |'.......|.DBF....|
|00001960| 03 00 44 42 43 36 06 d9 | 0d 00 3b 45 78 63 6c 75 |..DBC6..|..;Exclu|
|00001970| 73 69 76 65 3d 4e 6f 06 | d9 15 00 3b 42 61 63 6b |sive=No.|...;Back|
|00001980| 67 72 6f 75 6e 64 46 65 | 74 63 68 3d 59 65 73 3b |groundFe|tch=Yes;|
|00001990| 06 fd fe 0d 00 18 48 f9 | 05 15 14 f9 05 8b 14 fe |......H.|........|
|000019a0| 1e 00 0c fc 43 d9 0a 00 | 73 6f 75 72 63 65 74 79 |....C...|sourcety|
|000019b0| 70 65 ea 89 f8 01 03 10 | fd f9 05 5d 14 fe 2a 00 |pe......|...]..*.|
|000019c0| 54 f6 02 00 fc f8 01 02 | fd 16 10 fc f5 0d f7 01 |T.......|........|
|000019d0| 00 d9 01 00 60 06 43 26 | 06 d9 01 00 60 06 d9 01 |....`.C&|....`...|
|000019e0| 00 20 06 43 1b 06 fd fe | 08 00 32 f9 05 8b 14 fe |. .C....|..2.....|
|000019f0| 26 00 54 f6 02 00 fc f8 | 01 02 fd 16 10 fc f5 0d |&.T.....|........|
|00001a00| f7 01 00 f5 0d f7 09 00 | 06 d9 01 00 20 06 f5 0d |........|.... ...|
|00001a10| f7 09 00 06 fd fe 04 00 | 1c fe 14 00 99 fc 43 f8 |........|......C.|
|00001a20| 01 02 18 f7 02 00 f4 06 | 00 f6 44 00 fd fe 6b 00 |........|..D...k.|
|00001a30| 25 fc f4 10 00 f7 30 00 | f1 58 00 43 d9 1b 00 78 |%.....0.|.X.C...x|
|00001a40| 6c 61 70 70 2e 61 63 74 | 69 76 65 63 65 6c 6c 2e |lapp.act|ivecell.|
|00001a50| 70 69 76 6f 74 74 61 62 | 6c 65 62 d9 01 00 4f 0f |pivottab|leb...O.|
|00001a60| f0 2e 00 43 d9 23 00 78 | 6c 61 63 74 69 76 65 73 |...C.#.x|lactives|
|00001a70| 68 65 65 74 2e 63 65 6c | 6c 73 28 31 2c 31 29 2e |heet.cel|ls(1,1).|
|00001a80| 70 69 76 6f 74 74 61 62 | 6c 65 62 d9 01 00 4f 0f |pivottab|leb...O.|
|00001a90| 09 03 0b fd f9 05 1e 15 | fe 0c 00 99 fc 43 f7 45 |........|.....C.E|
|00001aa0| 00 ea 78 fd fe 04 00 42 | fe 04 00 1e fe 17 00 54 |..x....B|.......T|
|00001ab0| f7 0e 00 10 fc 43 f8 01 | 01 f4 06 00 e5 46 00 f7 |.....C..|.....F..|
|00001ac0| 47 00 fd fe 13 00 25 fc | 43 f4 10 00 f7 1d 00 a1 |G.....%.|C.......|
|00001ad0| 0a fd f9 05 6a 15 fe 1e | 00 99 f4 06 00 e5 46 00 |....j...|......F.|
|00001ae0| fc f5 0d f7 0e 00 fd 03 | f6 48 00 fc f4 10 00 f7 |........|.H......|
|00001af0| 1d 00 fd 03 fe 04 00 1e | fe 13 00 25 fc 43 f4 10 |........|...%.C..|
|00001b00| 00 f7 1f 00 a1 0a fd f9 | 05 a8 15 fe 27 00 54 f4 |........|....'.T.|
|00001b10| 06 00 e5 46 00 fc f5 0d | f7 0e 00 fd 03 e5 49 00 |...F....|......I.|
|00001b20| fc f4 10 00 f7 1f 00 fd | 03 f7 4a 00 10 fc f8 01 |........|..J.....|
|00001b30| 02 fd fe 04 00 1e fe 13 | 00 25 fc 43 f4 10 00 f7 |........|.%.C....|
|00001b40| 20 00 a1 0a fd f9 05 e6 | 15 fe 27 00 54 f4 06 00 | .......|..'.T...|
|00001b50| e5 46 00 fc f5 0d f7 0e | 00 fd 03 e5 49 00 fc f4 |.F......|....I...|
|00001b60| 10 00 f7 20 00 fd 03 f7 | 4a 00 10 fc f8 01 03 fd |... ....|J.......|
|00001b70| fe 04 00 1e fe 13 00 25 | fc 43 f4 10 00 f7 2e 00 |.......%|.C......|
|00001b80| a1 0a fd f9 05 84 17 fe | 27 00 54 f4 06 00 e5 46 |........|'.T....F|
|00001b90| 00 fc f5 0d f7 0e 00 fd | 03 e5 49 00 fc f4 10 00 |........|..I.....|
|00001ba0| f7 2e 00 fd 03 f7 4a 00 | 10 fc f8 01 04 fd fe 1b |......J.|........|
|00001bb0| 00 54 f7 4b 00 10 fc 43 | 43 00 f5 0d f7 0e 00 f4 |.T.K...C|C.......|
|00001bc0| 06 00 e5 46 00 f6 4c 00 | fd fe 1c 00 25 fc 43 f8 |...F..L.|....%.C.|
|00001bd0| 01 01 f4 4b 00 e5 4d 00 | f7 4e 00 f9 05 ef ef 10 |...K..M.|.N......|
|00001be0| fd f9 05 24 17 fe 1f 00 | 84 f7 03 00 10 fc f8 01 |...$....|........|
|00001bf0| 01 fd 28 fc 43 f4 10 00 | e0 13 00 f8 01 01 cd fd |..(.C...|........|
|00001c00| f9 05 de 16 fe 23 00 25 | fc 43 00 f5 0d f7 03 00 |.....#.%|.C......|
|00001c10| f8 01 01 f4 10 00 f6 13 | 00 43 f4 10 00 f7 2e 00 |........|.C......|
|00001c20| 66 14 fd f9 05 da 16 fe | 27 00 25 fc 43 43 00 f5 |f.......|'.%.CC..|
|00001c30| 0d f7 03 00 f8 01 02 f4 | 10 00 f6 13 00 d9 04 00 |........|........|
|00001c40| 4e 46 59 42 1d f8 01 00 | 0f fd f9 05 d2 16 fe 0e |NFYB....|........|
|00001c50| 00 54 f4 10 00 f7 4f 00 | 10 fc 61 fd fe 04 00 1e |.T....O.|..a.....|
|00001c60| fe 04 00 21 fe 04 00 1e | fe 04 00 85 fe 10 00 25 |...!....|.......%|
|00001c70| fc f4 10 00 f7 4f 00 fd | f9 05 20 17 fe 2e 00 54 |.....O..|.. ....T|
|00001c80| f4 06 00 e5 46 00 fc f5 | 0d f7 0e 00 fd 03 e5 49 |....F...|.......I|
|00001c90| 00 fc 43 f8 01 01 f4 4b | 00 e5 4d 00 f7 50 00 fd |..C....K|..M..P..|
|00001ca0| 03 f7 4e 00 10 fc f8 01 | 00 fd fe 04 00 1e fe 04 |..N.....|........|
|00001cb0| 00 1e fe 11 00 25 fc f4 | 10 00 f7 51 00 0a fd f9 |.....%..|...Q....|
|00001cc0| 05 52 17 fe 19 00 54 f4 | 06 00 e5 46 00 fc f5 0d |.R....T.|...F....|
|00001cd0| f7 0e 00 fd 03 f7 52 00 | 10 fc 2d fd fe 04 00 1e |......R.|..-.....|
|00001ce0| fe 11 00 25 fc f4 10 00 | f7 53 00 0a fd f9 05 80 |...%....|.S......|
|00001cf0| 17 fe 19 00 54 f4 06 00 | e5 46 00 fc f5 0d f7 0e |....T...|.F......|
|00001d00| 00 fd 03 f7 54 00 10 fc | 2d fd fe 04 00 1e fe 04 |....T...|-.......|
|00001d10| 00 1e fe 0d 00 99 fc 43 | f4 10 00 f6 31 00 fd fe |.......C|....1...|
|00001d20| 0d 00 18 48 f9 05 a2 17 | f9 05 6d 18 fe 14 00 0c |...H....|..m.....|
|00001d30| fc f4 10 00 f7 15 00 f8 | 01 01 10 fd f9 05 b6 17 |........|........|
|00001d40| fe 14 00 0c fc f4 10 00 | f7 15 00 f8 01 02 10 fd |........|........|
|00001d50| f9 05 6d 18 fe 13 00 99 | fc 43 f4 10 00 f7 56 00 |..m.....|.C....V.|
|00001d60| f4 3a 00 f6 55 00 fd fe | 1c 00 54 f5 0d f7 0f 00 |.:..U...|..T.....|
|00001d70| 10 fc d9 01 00 27 f4 10 | 00 f7 56 00 06 d9 01 00 |.....'..|..V.....|
|00001d80| 27 06 fd fe 11 00 25 fc | f4 10 00 f7 57 00 0a fd |'.....%.|....W...|
|00001d90| f9 05 35 18 fe 2b 00 01 | 5f 53 48 45 4c 4c 20 3d |..5..+..|_SHELL =|
|00001da0| 20 5b 4d 4f 44 49 46 59 | 20 46 4f 52 4d 20 26 63 | [MODIFY| FORM &c|
|00001db0| 4e 65 77 46 69 6c 65 20 | 4e 4f 57 41 49 54 5d 0a |NewFile |NOWAIT].|
|00001dc0| 04 00 1e fe 07 00 3c f7 | 06 00 fe 14 00 25 fc f5 |......<.|.....%..|
|00001dd0| 0d f7 0d 00 f9 02 ff ff | 10 fd f9 05 5e 18 fe 0a |........|....^...|
|00001de0| 00 99 f4 05 00 f7 58 00 | fe 04 00 1e fe 0b 00 3c |......X.|.......<|
|00001df0| f7 05 00 07 f7 3a 00 fe | 04 00 1c fe 03 00 55 59 |.....:..|......UY|
|00001e00| 00 08 00 43 44 42 51 50 | 41 54 48 0c 00 43 46 49 |...CDBQP|ATH..CFI|
|00001e10| 45 4c 44 53 54 52 49 4e | 47 0b 00 41 4f 44 42 43 |ELDSTRIN|G..AODBC|
|00001e20| 53 4f 55 52 43 45 01 00 | 49 02 00 58 4c 05 00 58 |SOURCE..|I..XL..X|
|00001e30| 4c 41 50 50 0d 00 58 4c | 41 43 54 49 56 45 53 48 |LAPP..XL|ACTIVESH|
|00001e40| 45 45 54 06 00 58 4c 46 | 4f 52 4d 08 00 43 54 48 |EET..XLF|ORM..CTH|
|00001e50| 49 53 44 42 46 09 00 43 | 56 49 45 57 4e 41 4d 45 |ISDBF..C|VIEWNAME|
|00001e60| 09 00 4c 43 4f 50 59 46 | 49 4c 45 0a 00 4c 4f 4c |..LCOPYF|ILE..LOL|
|00001e70| 44 53 45 54 4f 50 54 08 | 00 43 54 4d 50 4e 41 4d |DSETOPT.|.CTMPNAM|
|00001e80| 45 05 00 53 59 53 43 48 | 0a 00 43 50 49 56 4f 54 |E..SYSCH|..CPIVOT|
|00001e90| 4e 41 4d 45 08 00 43 4e | 45 57 46 49 4c 45 04 00 |NAME..CN|EWFILE..|
|00001ea0| 54 48 49 53 09 00 43 48 | 45 43 4b 44 41 54 41 06 |THIS..CH|ECKDATA.|
|00001eb0| 00 43 41 4c 49 41 53 08 | 00 41 46 4c 44 4c 49 53 |.CALIAS.|.AFLDLIS|
|00001ec0| 54 05 00 41 4c 45 52 54 | 07 00 4e 41 43 54 49 4f |T..ALERT|..NACTIO|
|00001ed0| 4e 08 00 43 46 4f 52 4d | 53 43 58 08 00 46 4f 52 |N..CFORM|SCX..FOR|
|00001ee0| 43 45 45 58 54 07 00 41 | 54 4d 50 41 52 52 08 00 |CEEXT..A|TMPARR..|
|00001ef0| 4e 50 41 47 45 43 4e 54 | 07 00 4e 43 4f 4c 43 4e |NPAGECNT|..NCOLCN|
|00001f00| 54 07 00 4e 52 4f 57 43 | 4e 54 09 00 4e 53 41 56 |T..NROWC|NT..NSAV|
|00001f10| 45 41 52 45 41 0a 00 43 | 50 49 56 46 4c 44 52 4f |EAREA..C|PIVFLDRO|
|00001f20| 57 08 00 44 49 53 54 49 | 4e 43 54 0a 00 43 50 49 |W..DISTI|NCT..CPI|
|00001f30| 56 46 4c 44 43 4f 4c 0b | 00 43 50 49 56 46 4c 44 |VFLDCOL.|.CPIVFLD|
|00001f40| 50 41 47 45 0a 00 47 45 | 54 44 4f 53 4e 41 4d 45 |PAGE..GE|TDOSNAME|
|00001f50| 09 00 4a 55 53 54 46 4e | 41 4d 45 08 00 4a 55 53 |..JUSTFN|AME..JUS|
|00001f60| 54 53 54 45 4d 0b 00 4c | 48 41 53 4d 53 51 52 59 |TSTEM..L|HASMSQRY|
|00001f70| 33 32 09 00 43 44 42 43 | 41 4c 49 41 53 0b 00 47 |32..CDBC|ALIAS..G|
|00001f80| 45 54 44 42 43 41 4c 49 | 41 53 08 00 43 44 42 43 |ETDBCALI|AS..CDBC|
|00001f90| 4e 41 4d 45 0d 00 4c 48 | 41 53 33 30 44 52 49 56 |NAME..LH|AS30DRIV|
|00001fa0| 45 52 53 0c 00 43 54 4d | 50 44 42 43 41 4c 49 41 |ERS..CTM|PDBCALIA|
|00001fb0| 53 09 00 43 44 42 43 54 | 41 42 4c 45 0a 00 44 42 |S..CDBCT|ABLE..DB|
|00001fc0| 46 54 59 50 45 5f 33 30 | 0e 00 43 5f 43 4f 50 59 |FTYPE_30|..C_COPY|
|00001fd0| 46 4f 58 32 5f 4c 4f 43 | 09 00 43 53 41 56 45 46 |FOX2_LOC|..CSAVEF|
|00001fe0| 49 4c 45 0b 00 43 50 49 | 56 46 4c 44 44 41 54 41 |ILE..CPI|VFLDDATA|
|00001ff0| 0b 00 43 48 45 43 4b 46 | 4c 44 4c 45 4e 08 00 48 |..CHECKF|LDLEN..H|
|00002000| 41 44 45 52 52 4f 52 0d | 00 44 49 53 50 4c 41 59 |ADERROR.|.DISPLAY|
|00002010| 53 54 41 54 55 53 0a 00 | 43 48 45 43 4b 53 54 41 |STATUS..|CHECKSTA|
|00002020| 54 45 07 00 43 41 50 54 | 49 4f 4e 07 00 56 49 53 |TE..CAPT|ION..VIS|
|00002030| 49 42 4c 45 09 00 57 4f | 52 4b 42 4f 4f 4b 53 03 |IBLE..WO|RKBOOKS.|
|00002040| 00 41 44 44 0b 00 41 43 | 54 49 56 45 53 48 45 45 |.ADD..AC|TIVESHEE|
|00002050| 54 09 00 43 46 4f 52 4d | 4e 41 4d 45 05 00 43 4f |T..CFORM|NAME..CO|
|00002060| 55 4e 54 0b 00 58 4c 50 | 49 56 4f 54 46 4f 52 4d |UNT..XLP|IVOTFORM|
|00002070| 0b 00 4f 4c 45 43 4f 4e | 54 52 4f 4c 31 06 00 4f |..OLECON|TROL1..O|
|00002080| 42 4a 45 43 54 0b 00 41 | 50 50 4c 49 43 41 54 49 |BJECT..A|PPLICATI|
|00002090| 4f 4e 06 00 50 41 52 45 | 4e 54 0a 00 57 4f 52 4b |ON..PARE|NT..WORK|
|000020a0| 53 48 45 45 54 53 07 00 | 57 49 4e 44 4f 57 53 08 |SHEETS..|WINDOWS.|
|000020b0| 00 41 43 54 49 56 41 54 | 45 0b 00 41 41 55 54 4f |.ACTIVAT|E..AAUTO|
|000020c0| 46 49 45 4c 44 53 09 00 | 43 4f 44 42 43 5f 44 53 |FIELDS..|CODBC_DS|
|000020d0| 4e 10 00 50 49 56 4f 54 | 54 41 42 4c 45 57 49 5a |N..PIVOT|TABLEWIZ|
|000020e0| 41 52 44 10 00 45 5f 4e | 4f 50 49 56 54 41 42 4c |ARD..E_N|OPIVTABL|
|000020f0| 45 5f 4c 4f 43 0b 00 50 | 49 56 4f 54 54 41 42 4c |E_LOC..P|IVOTTABL|
|00002100| 45 53 04 00 4e 41 4d 45 | 09 00 41 44 44 46 49 45 |ES..NAME|..ADDFIE|
|00002110| 4c 44 53 0b 00 50 49 56 | 4f 54 46 49 45 4c 44 53 |LDS..PIV|OTFIELDS|
|00002120| 0b 00 4f 52 49 45 4e 54 | 41 54 49 4f 4e 09 00 58 |..ORIENT|ATION..X|
|00002130| 4c 44 41 54 41 46 4c 44 | 0a 00 44 41 54 41 46 49 |LDATAFLD|..DATAFI|
|00002140| 45 4c 44 53 04 00 49 54 | 45 4d 08 00 46 55 4e 43 |ELDS..IT|EM..FUNC|
|00002150| 54 49 4f 4e 0a 00 4c 49 | 53 4e 55 4d 45 52 49 43 |TION..LI|SNUMERIC|
|00002160| 05 00 56 41 4c 55 45 10 | 00 4c 48 41 53 43 4f 4c |..VALUE.|.LHASCOL|
|00002170| 55 4d 4e 54 4f 54 41 4c | 53 0b 00 43 4f 4c 55 4d |UMNTOTAL|S..COLUM|
|00002180| 4e 47 52 41 4e 44 0d 00 | 4c 48 41 53 52 4f 57 54 |NGRAND..|LHASROWT|
|00002190| 4f 54 41 4c 53 08 00 52 | 4f 57 47 52 41 4e 44 06 |OTALS..R|OWGRAND.|
|000021a0| 00 53 41 56 45 41 53 08 | 00 43 4f 55 54 46 49 4c |.SAVEAS.|.COUTFIL|
|000021b0| 45 0a 00 4c 48 41 53 4e | 4f 54 41 53 4b 04 00 51 |E..LHASN|OTASK..Q|
|000021c0| 55 49 54 0f 02 0b 00 af | f7 00 00 07 f7 01 00 fe |UIT.....|........|
|000021d0| 13 00 ae f7 02 00 07 f7 | 03 00 07 f7 04 00 07 f7 |........|........|
|000021e0| 05 00 fe 19 00 54 f7 00 | 00 10 fc 43 f5 0d f7 00 |.....T..|...C....|
|000021f0| 00 d9 01 00 20 d9 01 00 | 5f a8 fd fe b6 00 54 f7 |.... ...|_.....T.|
|00002200| 03 00 10 fc fb 35 00 81 | 82 83 84 85 86 87 88 89 |.....5..|........|
|00002210| 8a 8b 8c 8e 8f 90 91 92 | 93 94 95 96 97 98 99 9a |........|........|
|00002220| a0 a1 a2 a3 a4 a5 2f 2c | 2d 3d 3b 7b 7d 5b 5d 21 |....../,|-=;{}[]!|
|00002230| 40 23 24 25 5e 26 2a 3c | 3e 28 29 3f fb 32 00 2b |@#$%^&*<|>()?.2.+|
|00002240| 7c 80 9b 9c 9d 9e 9f a6 | a7 a8 a9 aa ab ac ad ae ||.......|........|
|00002250| af b0 b1 b2 b3 b4 b5 b6 | b7 b8 b9 ba bb bc bd be |........|........|
|00002260| bf c0 c1 c2 c3 c4 c5 c6 | c7 c8 c9 ca cb cc cd ce |........|........|
|00002270| cf 06 fb 2f 00 d0 d1 d2 | d3 d4 d5 d6 d7 d8 d9 da |.../....|........|
|00002280| db dc dd de df e0 e1 e2 | e3 e4 e5 e6 e7 e8 e9 ea |........|........|
|00002290| eb ec ed ee ef f0 f1 f2 | f3 f4 f5 f6 f7 f8 f9 fa |........|........|
|000022a0| fb fc fd fe 06 43 f8 02 | 27 20 06 d9 01 00 20 06 |.....C..|' .... .|
|000022b0| fd fe 0d 00 54 f7 02 00 | 10 fc d9 00 00 fd fe 10 |....T...|........|
|000022c0| 00 54 f7 04 00 10 fc d9 | 03 00 3a 5c 2e fd fe 35 |.T......|..:\...5|
|000022d0| 00 25 fc 43 c4 f8 01 01 | 10 f1 22 00 43 d9 0c 00 |.%.C....|..".C...|
|000022e0| 6d 2e 6c 70 61 74 68 63 | 68 65 63 6b 62 d9 01 00 |m.lpathc|heckb...|
|000022f0| 4c 10 f0 07 00 f5 0d f7 | 01 00 0a 09 03 0b fd f9 |L.......|........|
|00002300| 05 54 01 fe 15 00 54 f7 | 03 00 10 fc f5 0d f7 03 |.T....T.|........|
|00002310| 00 f5 0d f7 04 00 06 fd | fe 04 00 1e fe 1b 00 84 |........|........|
|00002320| f7 05 00 10 fc f8 01 01 | fd 28 fc 43 f5 0d f7 03 |........|.(.C....|
|00002330| 00 3e fd f9 05 b1 01 fe | 1b 00 25 fc 43 43 f5 0d |.>......|..%.CC..|
|00002340| f7 03 00 f5 0d f7 05 00 | f8 01 01 5c 39 fd f9 05 |........|...\9...|
|00002350| ad 01 fe 1f 00 54 f7 02 | 00 10 fc f5 0d f7 02 00 |.....T..|........|
|00002360| 43 f5 0d f7 03 00 f5 0d | f7 05 00 f8 01 01 5c 06 |C.......|......\.|
|00002370| fd fe 04 00 1e fe 04 00 | 85 fe 19 00 54 f7 03 00 |........|....T...|
|00002380| 10 fc 43 f5 0d f7 03 00 | f5 0d f7 02 00 fb 00 00 |..C.....|........|
|00002390| 9d fd fe 33 00 54 f7 00 | 00 10 fc 43 43 f5 0d f7 |...3.T..|...CC...|
|000023a0| 00 00 f5 0d f7 03 00 43 | d9 01 00 5f 43 f5 0d f7 |.......C|..._C...|
|000023b0| 03 00 3e f8 01 01 08 51 | 9d f8 01 01 43 f5 0d f7 |..>....Q|....C...|
|000023c0| 00 00 3e 5c fd fe 0b 00 | 42 fc f5 0d f7 00 00 fd |..>\....|B.......|
|000023d0| fe 03 00 55 06 00 0c 00 | 43 44 4f 53 46 49 4c 45 |...U....|CDOSFILE|
|000023e0| 4e 41 4d 45 0a 00 4c 50 | 41 54 48 43 48 45 43 4b |NAME..LP|ATHCHECK|
|000023f0| 09 00 47 4f 4f 44 43 48 | 41 52 53 08 00 42 41 44 |..GOODCH|ARS..BAD|
|00002400| 43 48 41 52 53 09 00 50 | 41 54 48 43 48 41 52 53 |CHARS..P|ATHCHARS|
|00002410| 01 00 49 3c 03 1f 00 ae | f7 00 00 07 f7 01 00 07 |..I<....|........|
|00002420| f7 02 00 07 f7 03 00 07 | f7 04 00 07 f7 05 00 07 |........|........|
|00002430| f7 06 00 fe 2d 00 54 f7 | 06 00 10 fc 43 f4 07 00 |....-.T.|....C...|
|00002440| f7 08 00 f8 01 01 10 f2 | 0e 00 fa 0b 00 00 00 00 |........|........|
|00002450| 00 00 00 e0 c1 f3 06 00 | e9 0b 02 00 00 80 36 fd |........|......6.|
|00002460| fe 22 00 25 fc d9 08 00 | 52 45 47 49 53 54 52 59 |.".%....|REGISTRY|
|00002470| 43 d9 05 00 43 4c 41 53 | 53 76 01 03 0a fd f9 05 |C...CLAS|Sv......|
|00002480| 80 00 fe 12 00 47 7e 28 | fb 08 00 72 65 67 69 73 |.....G~(|...regis|
|00002490| 74 72 79 01 fe 04 00 1e | fe 19 00 54 f7 04 00 10 |try.....|...T....|
|000024a0| fc 43 fb 09 00 4f 6c 64 | 49 4e 49 52 65 67 ea 4e |.C...Old|INIReg.N|
|000024b0| fd fe 0d 00 54 f7 05 00 | 10 fc d9 00 00 fd fe 5b |....T...|.......[|
|000024c0| 00 25 fc 43 d9 04 00 50 | 61 74 68 18 f7 05 00 d9 |.%.C...P|ath.....|
|000024d0| 27 00 53 6f 66 74 77 61 | 72 65 5c 4d 69 63 72 6f |'.Softwa|re\Micro|
|000024e0| 73 6f 66 74 5c 53 68 61 | 72 65 64 20 54 6f 6f 6c |soft\Sha|red Tool|
|000024f0| 73 5c 4d 53 51 75 65 72 | 79 00 f5 0d f7 06 00 f4 |s\MSQuer|y.......|
|00002500| 04 00 f6 0a 00 f8 01 00 | 10 f0 08 00 43 f5 0d f7 |........|....C...|
|00002510| 05 00 30 09 fd f9 05 36 | 01 fe 0b 00 54 f7 00 00 |..0....6|....T...|
|00002520| 10 fc 61 fd fe 26 00 54 | f4 07 00 f7 0b 00 10 fc |..a..&.T|........|
|00002530| 43 d9 0b 00 4d 53 51 52 | 59 33 32 2e 45 58 45 f5 |C...MSQR|Y32.EXE.|
|00002540| 0d f7 05 00 b8 f8 01 00 | 0f fd fe 04 00 1e fe 0d |........|........|
|00002550| 00 18 48 f9 05 47 01 f9 | 05 a0 02 fe 0f 00 0c fc |..H..G..|........|
|00002560| f5 0d f7 00 00 fd f9 05 | 56 01 fe 36 00 0c fc 43 |........|V..6...C|
|00002570| 43 d9 06 00 77 69 6e 64 | 69 72 35 d9 1b 00 5c 4d |C...wind|ir5...\M|
|00002580| 53 41 50 50 53 5c 4d 53 | 51 55 45 52 59 5c 4d 53 |SAPPS\MS|QUERY\MS|
|00002590| 51 55 45 52 59 2e 45 58 | 45 06 30 fd f9 05 97 01 |QUERY.EX|E.0.....|
|000025a0| fe 0b 00 54 f7 00 00 10 | fc 61 fd fe 08 00 32 f9 |...T....|.a....2.|
|000025b0| 05 a0 02 fe 0d 00 15 f6 | 01 00 fc f8 01 01 fd 16 |........|........|
|000025c0| fe 22 00 25 fc 43 18 f7 | 01 00 d9 06 00 4d 53 41 |.".%.C..|.....MSA|
|000025d0| 50 50 53 f4 04 00 f6 0c | 00 f8 01 00 10 fd f9 05 |PPS.....|........|
|000025e0| 6d 02 fe 1b 00 54 f7 02 | 00 10 fc 43 eb f7 01 00 |m....T..|...C....|
|000025f0| d9 07 00 4d 53 51 55 45 | 52 59 ea 11 fd fe 13 00 |...MSQUE|RY......|
|00002600| 25 fc f5 0d f7 02 00 f8 | 01 00 0f fd f9 05 69 02 |%.......|......i.|
|00002610| fe 0d 00 54 f7 03 00 10 | fc d9 00 00 fd fe 2c 00 |...T....|......,.|
|00002620| 25 fc 43 18 f7 03 00 d9 | 06 00 4d 53 41 50 50 53 |%.C.....|..MSAPPS|
|00002630| d9 07 00 4d 53 51 55 45 | 52 59 f4 04 00 f6 0d 00 |...MSQUE|RY......|
|00002640| f8 01 00 10 fd f9 05 65 | 02 fe 21 00 25 fc 43 f5 |.......e|..!.%.C.|
|00002650| 0d f7 03 00 d9 0c 00 5c | 4d 53 51 55 45 52 59 2e |.......\|MSQUERY.|
|00002660| 45 58 45 06 30 fd f9 05 | 61 02 fe 0b 00 54 f7 00 |EXE.0...|a....T..|
|00002670| 00 10 fc 61 fd fe 04 00 | 1e fe 04 00 1e fe 04 00 |...a....|........|
|00002680| 1e fe 04 00 1e fe 20 00 | 25 fc f7 00 00 0a f0 0f |...... .|%.......|
|00002690| 00 43 d9 04 00 2e 71 72 | 79 f4 04 00 f6 0e 00 09 |.C....qr|y.......|
|000026a0| fd f9 05 9c 02 fe 0b 00 | 54 f7 00 00 10 fc 61 fd |........|T.....a.|
|000026b0| fe 04 00 1e fe 04 00 1c | fe 10 00 25 fc f5 0d f7 |........|...%....|
|000026c0| 00 00 0a fd f9 05 2a 03 | fe 76 00 99 fc 43 d9 66 |......*.|.v...C.f|
|000026d0| 00 4d 69 63 72 6f 73 6f | 66 74 20 51 75 65 72 79 |.Microso|ft Query|
|000026e0| 20 68 61 73 20 6e 6f 74 | 20 62 65 65 6e 20 69 6e | has not| been in|
|000026f0| 73 74 61 6c 6c 65 64 20 | 70 72 6f 70 65 72 6c 79 |stalled |properly|
|00002700| 20 61 6e 64 20 69 73 20 | 6e 65 65 64 65 64 20 69 | and is |needed i|
|00002710| 6e 20 6f 72 64 65 72 20 | 74 6f 20 63 72 65 61 74 |n order |to creat|
|00002720| 65 20 61 6e 20 45 78 63 | 65 6c 20 70 69 76 6f 74 |e an Exc|el pivot|
|00002730| 20 74 61 62 6c 65 2e f4 | 07 00 f6 0f 00 fd fe 04 | table..|........|
|00002740| 00 1e fe 0b 00 42 fc f5 | 0d f7 00 00 fd fe 03 00 |.....B..|........|
|00002750| 55 10 00 0b 00 4c 48 41 | 53 4d 53 51 55 45 52 59 |U....LHA|SMSQUERY|
|00002760| 07 00 41 4d 53 41 50 50 | 53 04 00 4e 50 4f 53 06 |..AMSAPP|S..NPOS.|
|00002770| 00 43 56 41 4c 55 45 04 | 00 4f 52 45 47 0a 00 43 |.CVALUE.|.OREG..C|
|00002780| 50 41 54 48 56 41 4c 55 | 45 05 00 43 48 4b 45 59 |PATHVALU|E..CHKEY|
|00002790| 04 00 54 48 49 53 0a 00 | 4e 43 55 52 52 45 4e 54 |..THIS..|NCURRENT|
|000027a0| 4f 53 08 00 52 45 47 49 | 53 54 52 59 09 00 47 45 |OS..REGI|STRY..GE|
|000027b0| 54 52 45 47 4b 45 59 0b | 00 4c 48 41 53 4d 53 51 |TREGKEY.|.LHASMSQ|
|000027c0| 52 59 33 32 0d 00 47 45 | 54 49 4e 49 53 45 43 54 |RY32..GE|TINISECT|
|000027d0| 49 4f 4e 0b 00 47 45 54 | 49 4e 49 45 4e 54 52 59 |ION..GET|INIENTRY|
|000027e0| 05 00 49 53 4b 45 59 05 | 00 41 4c 45 52 54 b1 01 |..ISKEY.|.ALERT..|
|000027f0| 13 00 ae f7 00 00 07 f7 | 01 00 07 f7 02 00 07 f7 |........|........|
|00002800| 03 00 fe 0d 00 54 f7 00 | 00 10 fc d9 00 00 fd fe |.....T..|........|
|00002810| 0d 00 54 f7 01 00 10 fc | d9 00 00 fd fe 17 00 54 |..T.....|.......T|
|00002820| f7 03 00 10 fc 43 fb 07 | 00 46 69 6c 65 52 65 67 |.....C..|.FileReg|
|00002830| ea 4e fd fe 27 00 54 f7 | 02 00 10 fc 43 d9 0b 00 |.N..'.T.|....C...|
|00002840| 45 78 63 65 6c 2e 53 68 | 65 65 74 18 f7 00 00 18 |Excel.Sh|eet.....|
|00002850| f7 01 00 f4 03 00 f6 04 | 00 fd fe 13 00 25 fc f5 |........|.....%..|
|00002860| 0d f7 02 00 f8 01 00 0f | fd f9 05 f5 00 fe 6e 00 |........|......n.|
|00002870| 99 fc 43 d9 5e 00 4d 69 | 63 72 6f 73 6f 66 74 20 |..C.^.Mi|crosoft |
|00002880| 45 78 63 65 6c 20 69 73 | 20 6e 6f 74 20 70 72 6f |Excel is| not pro|
|00002890| 70 65 72 6c 79 20 72 65 | 67 69 73 74 65 72 65 64 |perly re|gistered|
|000028a0| 20 69 6e 20 74 68 65 20 | 57 69 6e 64 6f 77 73 20 | in the |Windows |
|000028b0| 72 65 67 69 73 74 72 61 | 74 69 6f 6e 20 74 61 62 |registra|tion tab|
|000028c0| 6c 65 20 66 6f 72 20 75 | 73 65 20 77 69 74 68 20 |le for u|se with |
|000028d0| 4f 4c 45 2e f4 05 00 f6 | 06 00 fd fe 09 00 42 fc |OLE.....|......B.|
|000028e0| d9 00 00 fd fe 04 00 1e | fe 1a 00 25 fc 43 43 f5 |........|...%.CC.|
|000028f0| 0d f7 00 00 f8 01 01 52 | 67 f8 01 05 0d fd f9 05 |.......R|g.......|
|00002900| 9f 01 fe 83 00 99 fc 43 | d9 73 00 54 68 65 20 61 |.......C|.s.The a|
|00002910| 75 74 6f 6d 61 74 69 6f | 6e 20 74 6f 6f 6c 20 64 |utomatio|n tool d|
|00002920| 6f 65 73 20 6e 6f 74 20 | 73 75 70 70 6f 72 74 20 |oes not |support |
|00002930| 79 6f 75 72 20 76 65 72 | 73 69 6f 6e 20 6f 66 20 |your ver|sion of |
|00002940| 4d 69 63 72 6f 73 6f 66 | 74 20 45 78 63 65 6c 2e |Microsof|t Excel.|
|00002950| 20 59 6f 75 20 6d 75 73 | 74 20 68 61 76 65 20 76 | You mus|t have v|
|00002960| 65 72 73 69 6f 6e 20 35 | 2e 30 20 6f 72 20 6c 61 |ersion 5|.0 or la|
|00002970| 74 65 72 20 69 6e 73 74 | 61 6c 6c 65 64 2e f4 05 |ter inst|alled...|
|00002980| 00 f6 06 00 fd fe 09 00 | 42 fc d9 00 00 fd fe 04 |........|B.......|
|00002990| 00 1e fe 0b 00 42 fc f5 | 0d f7 01 00 fd fe 03 00 |.....B..|........|
|000029a0| 55 07 00 07 00 43 41 50 | 50 4b 45 59 08 00 43 41 |U....CAP|PKEY..CA|
|000029b0| 50 50 4e 41 4d 45 07 00 | 4e 45 52 52 4e 55 4d 04 |PPNAME..|NERRNUM.|
|000029c0| 00 4f 52 45 47 10 00 47 | 45 54 4c 41 54 45 53 54 |.OREG..G|ETLATEST|
|000029d0| 56 45 52 53 49 4f 4e 04 | 00 54 48 49 53 05 00 41 |VERSION.|.THIS..A|
|000029e0| 4c 45 52 54 5c 00 07 00 | af f7 00 00 fe 0d 00 18 |LERT\...|........|
|000029f0| 48 f9 05 14 00 f9 05 55 | 00 fe 1e 00 0c fc 43 f5 |H......U|......C.|
|00002a00| 0d f7 00 00 a1 f1 0a 00 | 43 f7 00 00 3e f8 02 0b |........|C...>...|
|00002a10| 0d 0b fd f9 05 3d 00 fe | 0b 00 42 fc f5 0d f7 00 |.....=..|..B.....|
|00002a20| 00 fd fe 08 00 32 f9 05 | 55 00 fe 10 00 42 fc 43 |.....2..|U....B.C|
|00002a30| f5 0d f7 00 00 f8 02 0a | 3d fd fe 04 00 1c fe 03 |........|=.......|
|00002a40| 00 55 01 00 08 00 43 46 | 4c 44 4e 41 4d 45 0d 00 |.U....CF|LDNAME..|
|00002a50| 0a 00 99 f4 00 00 f7 01 | 00 fe 03 00 55 02 00 04 |........|....U...|
|00002a60| 00 54 48 49 53 0b 00 50 | 49 56 4f 54 4f 55 54 50 |.THIS..P|IVOTOUTP|
|00002a70| 55 54 69 00 13 00 25 fc | 43 df e3 00 00 f6 01 00 |UTi...%.|C.......|
|00002a80| 0a fd f9 05 1a 00 fe 07 | 00 42 fc 2d fd fe 04 00 |........|.B.-....|
|00002a90| 1e fe 12 00 25 fc 43 f4 | 02 00 f6 03 00 0a fd f9 |....%.C.|........|
|00002aa0| 05 37 00 fe 07 00 42 fc | 2d fd fe 04 00 1e fe 13 |.7....B.|-.......|
|00002ab0| 00 25 fc 43 43 f4 02 00 | f6 04 00 a1 fd f9 05 55 |.%.CC...|.......U|
|00002ac0| 00 fe 07 00 42 fc 2d fd | fe 04 00 1e fe 0d 00 42 |....B.-.|.......B|
|00002ad0| fc 43 f4 02 00 f6 05 00 | fd fe 03 00 55 06 00 0a |.C......|....U...|
|00002ae0| 00 41 55 54 4f 4d 41 54 | 49 4f 4e 04 00 49 4e 49 |.AUTOMAT|ION..INI|
|00002af0| 54 04 00 54 48 49 53 09 | 00 4f 44 42 43 43 48 45 |T..THIS.|.ODBCCHE|
|00002b00| 43 4b 09 00 47 45 54 58 | 4c 50 41 54 48 0c 00 4d |CK..GETX|LPATH..M|
|00002b10| 53 51 55 45 52 59 43 48 | 45 43 4b a8 01 0f 00 34 |SQUERYCH|ECK....4|
|00002b20| f7 00 00 07 f7 01 00 07 | f7 02 00 fe 07 00 ae f7 |........|........|
|00002b30| 03 00 fe 0d 00 15 f6 03 | 00 fc f8 01 01 fd 16 fe |........|........|
|00002b40| 0e 00 54 f4 04 00 f7 05 | 00 10 fc 61 fd fe 12 00 |..T.....|...a....|
|00002b50| 86 fc 43 f9 04 be 0b f4 | 04 00 f7 06 00 5d fd fe |..C.....|.....]..|
|00002b60| 16 00 25 fc 43 ea 19 f7 | 03 00 ea 7a f8 01 00 11 |..%.C...|...z....|
|00002b70| fd f9 05 87 01 fe 0d 00 | 18 48 f9 05 66 00 f9 05 |........|.H..f...|
|00002b80| 5c 01 fe 41 00 0c fc f4 | 04 00 f7 07 00 f0 0d 00 |\..A....|........|
|00002b90| 43 f8 01 01 f6 03 00 f9 | 04 92 05 10 09 f0 1e 00 |C.......|........|
|00002ba0| 43 d9 0d 00 43 41 4c 4c | 5f 52 45 4a 45 43 54 45 |C...CALL|_REJECTE|
|00002bb0| 44 43 f8 01 02 f6 03 00 | b8 f8 01 00 0f 09 fd f9 |DC......|........|
|00002bc0| 05 b8 00 fe 11 00 99 fc | 43 00 f7 09 00 f4 04 00 |........|C.......|
|00002bd0| f6 08 00 fd fe 2c 00 0c | fc 43 f8 01 01 f8 01 01 |.....,..|.C......|
|00002be0| f6 03 00 f9 04 95 05 10 | f0 10 00 43 f8 01 01 f8 |........|...C....|
|00002bf0| 01 07 f6 03 00 f9 04 ed | 03 10 09 fd f9 05 e4 00 |........|........|
|00002c00| fe 1b 00 0c fc 43 43 f8 | 01 01 f6 03 00 f9 04 8c |.....CC.|........|
|00002c10| 05 f9 04 b4 05 ab fd f9 | 05 5c 01 fe 5d 00 99 fc |........|.\..]...|
|00002c20| 43 d9 4d 00 41 6e 20 4f | 4c 45 20 61 75 74 6f 6d |C.M.An O|LE autom|
|00002c30| 61 74 69 6f 6e 20 65 72 | 72 6f 72 20 6f 63 63 75 |ation er|ror occu|
|00002c40| 72 72 65 64 2e 20 59 6f | 75 72 20 45 78 63 65 6c |rred. Yo|ur Excel|
|00002c50| 20 70 69 76 6f 74 20 74 | 61 62 6c 65 20 6d 61 79 | pivot t|able may|
|00002c60| 20 6e 6f 74 20 62 65 20 | 63 6f 6d 70 6c 65 74 65 | not be |complete|
|00002c70| 2e f4 04 00 f6 08 00 fd | fe 04 00 1c fe 1b 00 25 |........|.......%|
|00002c80| fc 43 43 f8 01 01 f6 03 | 00 f9 04 8c 05 f9 04 b4 |.CC.....|........|
|00002c90| 05 ab fd f9 05 83 01 fe | 08 00 42 28 f7 0a 00 fe |........|..B(....|
|00002ca0| 04 00 1e fe 04 00 1e fe | 1a 00 99 fc 43 00 f7 00 |........|....C...|
|00002cb0| 00 00 f7 01 00 00 f7 02 | 00 df e3 0b 00 f6 0c 00 |........|........|
|00002cc0| fd fe 03 00 55 0d 00 02 | 00 50 31 02 00 50 32 02 |....U...|.P1..P2.|
|00002cd0| 00 50 33 07 00 41 45 52 | 52 4f 52 53 04 00 54 48 |.P3..AER|RORS..TH|
|00002ce0| 49 53 08 00 48 41 44 45 | 52 52 4f 52 0d 00 4e 53 |IS..HADE|RROR..NS|
|00002cf0| 41 56 45 4c 4f 43 41 4c | 45 49 44 0a 00 43 48 45 |AVELOCAL|EID..CHE|
|00002d00| 43 4b 53 54 41 54 45 05 | 00 41 4c 45 52 54 10 00 |CKSTATE.|.ALERT..|
|00002d10| 45 5f 58 4c 42 41 44 53 | 54 41 54 45 5f 4c 4f 43 |E_XLBADS|TATE_LOC|
|00002d20| 0a 00 4d 41 4b 45 4f 55 | 54 50 55 54 0a 00 41 55 |..MAKEOU|TPUT..AU|
|00002d30| 54 4f 4d 41 54 49 4f 4e | 05 00 45 52 52 4f 52 0b |TOMATION|..ERROR.|
|00002d40| 00 70 69 76 6f 74 6f 75 | 74 70 75 74 2c 00 00 00 |.pivotou|tput,...|
|00002d50| 00 00 ff ff 0a 00 67 65 | 74 64 6f 73 6e 61 6d 65 |......ge|tdosname|
|00002d60| 66 1c 00 00 00 00 ff ff | 0c 00 6d 73 71 75 65 72 |f.......|..msquer|
|00002d70| 79 63 68 65 63 6b b6 1e | 00 00 00 00 ff ff 09 00 |ycheck..|........|
|00002d80| 67 65 74 78 6c 70 61 74 | 68 91 22 00 00 00 00 ff |getxlpat|h.".....|
|00002d90| ff 0b 00 63 68 65 63 6b | 66 6c 64 6c 65 6e 87 24 |...check|fldlen.$|
|00002da0| 00 00 00 00 ff ff 0a 00 | 6d 61 6b 65 6f 75 74 70 |........|makeoutp|
|00002db0| 75 74 f1 24 00 00 00 00 | ff ff 04 00 49 6e 69 74 |ut.$....|....Init|
|00002dc0| 15 25 00 00 00 00 ff ff | 05 00 45 72 72 6f 72 be |.%......|..Error.|
|00002dd0| 25 00 00 00 00 ff ff 31 | 00 71 01 f1 01 31 01 d2 |%......1|.q...1..|
|00002de0| 00 f1 00 22 01 41 00 41 | 00 d2 00 62 01 01 01 f1 |...".A.A|...b....|
|00002df0| 00 41 00 02 01 11 06 41 | 00 41 00 54 05 b2 03 41 |.A.....A|.A.T...A|
|00002e00| 00 41 00 13 01 72 01 d1 | 00 51 01 c1 00 31 01 a1 |.A...r..|.Q...1..|
|00002e10| 01 e1 00 41 00 42 01 31 | 01 a1 01 e1 00 41 00 31 |...A.B.1|.....A.1|
|00002e20| 01 31 01 a1 01 e1 00 41 | 00 41 00 41 00 22 01 c1 |.1.....A|.A.A."..|
|00002e30| 00 41 00 85 04 81 07 41 | 00 41 00 41 00 41 00 e3 |.A.....A|.A.A.A..|
|00002e40| 01 41 01 83 03 12 01 91 | 19 b1 00 81 00 41 00 41 |.A......|.....A.A|
|00002e50| 00 41 00 41 00 41 00 a2 | 01 d3 02 f1 0b 01 01 e1 |.A.A.A..|........|
|00002e60| 00 51 00 f1 00 81 01 81 | 00 41 00 41 00 41 00 44 |.Q......|.A.A.A.D|
|00002e70| 04 f1 01 b1 00 81 00 41 | 00 41 00 41 00 f3 00 92 |.......A|.A.A....|
|00002e80| 00 e2 01 a1 01 81 00 31 | 01 41 00 d3 00 51 01 41 |.......1|.A...Q.A|
|00002e90| 01 81 02 91 01 81 00 91 | 01 41 00 73 01 c1 00 01 |........|.A.s....|
|00002ea0| 03 11 01 41 00 41 00 d3 | 01 81 01 33 04 91 19 41 |...A.A..|...3...A|
|00002eb0| 00 41 00 71 01 81 00 41 | 00 41 00 41 00 f2 00 23 |.A.q...A|.A.A...#|
|00002ec0| 01 41 00 41 00 81 00 d1 | 00 e3 01 41 00 41 00 f1 |.A.A....|...A.A..|
|00002ed0| 00 a5 01 a1 01 a1 01 a1 | 01 42 00 54 02 e1 00 d1 |........|.B.T....|
|00002ee0| 00 81 01 41 00 41 00 f1 | 00 41 00 83 01 31 01 01 |...A.A..|.A...1..|
|00002ef0| 02 41 01 b1 02 11 02 81 | 00 e1 00 21 02 41 00 73 |.A......|...!.A.s|
|00002f00| 01 04 01 33 02 b1 02 41 | 00 81 00 e2 00 c1 00 01 |...3...A|........|
|00002f10| 01 41 00 41 00 e1 00 41 | 00 d2 00 41 01 e2 00 d2 |.A.A...A|...A....|
|00002f20| 00 01 01 42 01 b1 00 02 | 01 82 03 d1 00 41 00 f1 |...B....|.....A..|
|00002f30| 02 61 01 42 01 d1 01 81 | 00 31 01 01 01 41 00 41 |.a.B....|.1...A.A|
|00002f40| 00 02 01 41 00 41 00 d2 | 04 d3 00 a1 01 91 01 e1 |...A.A..|........|
|00002f50| 01 41 00 62 02 f1 00 d3 | 00 e1 01 c1 01 c1 02 81 |.A.b....|........|
|00002f60| 01 41 00 41 00 71 01 41 | 00 61 02 51 01 d1 01 41 |.A.A.q.A|.a.Q...A|
|00002f70| 00 b1 00 d1 01 81 00 c1 | 01 f1 01 81 01 41 00 41 |........|.....A.A|
|00002f80| 00 61 01 41 00 61 02 51 | 01 d1 01 41 00 41 00 d5 |.a.A.a.Q|...A.A..|
|00002f90| 00 f9 09 d2 00 e1 01 a1 | 02 81 00 61 02 41 00 42 |........|...a.A.B|
|00002fa0| 01 b4 06 c1 00 41 00 41 | 00 72 01 34 01 e1 01 41 |.....A.A|.r.4...A|
|00002fb0| 00 33 01 71 02 41 00 33 | 01 71 02 41 00 33 01 71 |.3.q.A.3|.q.A.3.q|
|00002fc0| 02 b1 01 c1 01 f2 01 31 | 02 71 02 e1 00 41 00 41 |.......1|.q...A.A|
|00002fd0| 00 41 00 41 00 01 01 e1 | 02 41 00 41 00 12 01 91 |.A.A....|.A.A....|
|00002fe0| 01 41 00 12 01 91 01 41 | 00 41 00 d2 00 d3 00 41 |.A.....A|.A.....A|
|00002ff0| 01 41 01 31 01 c1 01 11 | 01 b1 02 41 00 72 00 41 |.A.1....|...A.r.A|
|00003000| 01 a1 00 41 00 b1 00 41 | 00 33 00 b1 00 32 01 92 |...A...A|.3...2..|
|00003010| 01 66 0b d2 00 01 01 52 | 03 51 01 41 00 b2 01 b1 |.f.....R|.Q.A....|
|00003020| 01 f1 01 41 00 41 00 92 | 01 31 03 b2 00 33 00 f1 |...A.A..|.1...3..|
|00003030| 01 d3 02 21 02 21 01 41 | 00 92 01 d1 00 b3 05 b1 |...!.!.A|........|
|00003040| 00 61 02 41 00 d2 00 f1 | 00 61 03 b1 00 81 00 d2 |.a.A....|.a......|
|00003050| 00 21 02 b1 01 31 01 d1 | 00 c1 02 11 02 b1 00 41 |.!...1..|.......A|
|00003060| 00 41 00 41 00 41 00 03 | 02 b1 00 41 00 42 00 02 |.A.A.A..|...A.B..|
|00003070| 01 61 07 41 00 b2 00 33 | 00 33 01 d1 00 d1 00 72 |.a.A...3|.3.....r|
|00003080| 01 73 02 31 01 e1 06 91 | 00 41 00 a3 01 31 08 91 |.s.1....|.A...1..|
|00003090| 00 41 00 b2 00 33 00 71 | 00 d1 00 e1 01 b1 00 81 |.A...3.q|........|
|000030a0| 00 01 01 41 00 33 00 a1 | 00 33 00 31 01 71 00 41 |...A.3..|.3.1.q.A|
|000030b0| 00 23 01 71 00 41 00 33 | 01 71 00 41 00 d3 00 33 |.#.q.A.3|.q.A...3|
|000030c0| 00 f1 00 71 00 d1 00 e1 | 00 22 01 62 01 d1 00 11 |...q....|.".b....|
|000030d0| 04 11 01 c1 02 b4 01 d1 | 05 41 00 b2 01 81 00 41 |........|.A.....A|
|000030e0| 00 41 00 a2 01 32 00 00 | 00 00 00 00 00 00 00 00 |.A...2..|........|
|000030f0| 00 00 00 00 00 00 00 01 | 00 00 00 17 00 00 00 e7 |........|........|
|00003100| 29 00 00 01 00 00 00 1a | 01 00 00 08 2a 00 00 99 |).......|....*...|
|00003110| 2d 00 00 8c 01 00 00 2c | 01 00 00 bc 2d 00 00 63 |-......,|....-..c|
|00003120| 32 00 00 ac 01 00 00 51 | 01 00 00 83 32 00 00 48 |2......Q|....2..H|
|00003130| 34 00 00 df 01 00 00 60 | 01 00 00 6a 34 00 00 ff |4......`|...j4...|
|00003140| 34 00 00 f8 01 00 00 68 | 01 00 00 20 35 00 00 32 |4......h|... 5..2|
|00003150| 35 00 00 02 02 00 00 6a | 01 00 00 4d 35 00 00 5b |5......j|...M5..[|
|00003160| 36 00 00 06 02 00 00 75 | 01 00 00 77 36 00 00 02 |6......u|...w6...|
|00003170| 39 00 00 19 02 00 00 00 | 29 00 00 00 43 2c 00 00 |9.......|)...C,..|
|00003180| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003190| 00 00 00 01 00 00 39 0d | 50 52 4f 43 45 44 55 52 |......9.|PROCEDUR|
|000031a0| 45 20 70 69 76 6f 74 6f | 75 74 70 75 74 0d 0a 4c |E pivoto|utput..L|
|000031b0| 4f 43 41 4c 20 63 44 42 | 51 50 61 74 68 2c 63 46 |OCAL cDB|QPath,cF|
|000031c0| 69 65 6c 64 53 74 72 69 | 6e 67 2c 61 4f 44 42 43 |ieldStri|ng,aODBC|
|000031d0| 53 6f 75 72 63 65 2c 69 | 2c 78 6c 0d 0a 4c 4f 43 |Source,i|,xl..LOC|
|000031e0| 41 4c 20 78 6c 61 70 70 | 2c 78 6c 61 63 74 69 76 |AL xlapp|,xlactiv|
|000031f0| 65 73 68 65 65 74 2c 78 | 6c 66 6f 72 6d 2c 63 54 |esheet,x|lform,cT|
|00003200| 68 69 73 44 42 46 2c 63 | 56 69 65 77 4e 61 6d 65 |hisDBF,c|ViewName|
|00003210| 2c 6c 43 6f 70 79 46 69 | 6c 65 2c 6c 4f 6c 64 53 |,lCopyFi|le,lOldS|
|00003220| 65 74 4f 70 74 0d 0a 4c | 4f 43 41 4c 20 63 54 6d |etOpt..L|OCAL cTm|
|00003230| 70 4e 61 6d 65 2c 73 79 | 73 63 68 2c 63 50 69 76 |pName,sy|sch,cPiv|
|00003240| 6f 74 4e 61 6d 65 2c 63 | 4e 65 77 46 69 6c 65 0d |otName,c|NewFile.|
|00003250| 0a 0d 0a 6d 2e 6c 63 6f | 70 79 66 69 6c 65 20 3d |...m.lco|pyfile =|
|00003260| 20 2e 46 2e 0d 0a 6d 2e | 63 46 69 65 6c 64 53 74 | .F...m.|cFieldSt|
|00003270| 72 69 6e 67 20 3d 20 22 | 22 0d 0a 0d 0a 49 46 20 |ring = "|"....IF |
|00003280| 21 54 48 49 53 2e 43 68 | 65 63 6b 44 61 74 61 28 |!THIS.Ch|eckData(|
|00003290| 29 0d 0a 09 52 45 54 55 | 52 4e 0d 0a 45 4e 44 49 |)...RETU|RN..ENDI|
|000032a0| 46 0d 0a 0d 0a 53 45 4c | 45 43 54 20 28 54 48 49 |F....SEL|ECT (THI|
|000032b0| 53 2e 63 41 6c 69 61 73 | 29 0d 0a 0d 0a 49 46 20 |S.cAlias|)....IF |
|000032c0| 45 4d 50 54 59 28 54 48 | 49 53 2e 61 46 6c 64 4c |EMPTY(TH|IS.aFldL|
|000032d0| 69 73 74 5b 31 5d 29 0d | 0a 09 44 49 4d 45 4e 53 |ist[1]).|..DIMENS|
|000032e0| 49 4f 4e 20 54 48 49 53 | 2e 61 46 6c 64 4c 69 73 |ION THIS|.aFldLis|
|000032f0| 74 5b 31 5d 0d 0a 09 41 | 46 49 45 4c 44 53 28 54 |t[1]...A|FIELDS(T|
|00003300| 48 49 53 2e 61 46 6c 64 | 4c 69 73 74 29 0d 0a 45 |HIS.aFld|List)..E|
|00003310| 4e 44 49 46 0d 0a 0d 0a | 49 46 20 52 45 43 43 4f |NDIF....|IF RECCO|
|00003320| 55 4e 54 28 29 20 3d 20 | 30 0d 0a 09 54 48 49 53 |UNT() = |0...THIS|
|00003330| 2e 41 4c 45 52 54 28 43 | 5f 4e 4f 52 45 43 4f 52 |.ALERT(C|_NORECOR|
|00003340| 44 53 5f 4c 4f 43 29 0d | 0a 09 52 45 54 55 52 4e |DS_LOC).|..RETURN|
|00003350| 0d 0a 45 4e 44 49 46 0d | 0a 09 09 0d 0a 49 46 20 |..ENDIF.|.....IF |
|00003360| 54 48 49 53 2e 6e 41 63 | 74 69 6f 6e 20 3d 3d 20 |THIS.nAc|tion == |
|00003370| 32 20 41 4e 44 20 28 45 | 4d 50 54 59 28 54 48 49 |2 AND (E|MPTY(THI|
|00003380| 53 2e 63 46 6f 72 6d 53 | 43 58 29 20 4f 52 20 3b |S.cFormS|CX) OR ;|
|00003390| 0d 0a 09 21 46 49 4c 45 | 28 54 48 49 53 2e 46 6f |...!FILE|(THIS.Fo|
|000033a0| 72 63 65 45 78 74 28 54 | 48 49 53 2e 63 46 6f 72 |rceExt(T|HIS.cFor|
|000033b0| 6d 53 43 58 2c 22 53 43 | 58 22 29 29 20 4f 52 20 |mSCX,"SC|X")) OR |
|000033c0| 3b 0d 0a 09 21 46 49 4c | 45 28 54 48 49 53 2e 46 |;...!FIL|E(THIS.F|
|000033d0| 6f 72 63 65 45 78 74 28 | 54 48 49 53 2e 63 46 6f |orceExt(|THIS.cFo|
|000033e0| 72 6d 53 43 58 2c 22 53 | 43 54 22 29 29 29 0d 0a |rmSCX,"S|CT")))..|
|000033f0| 09 2a 2d 20 6e 6f 20 53 | 43 58 20 66 6f 72 6d 20 |.*- no S|CX form |
|00003400| 6e 61 6d 65 20 73 70 65 | 63 69 66 69 65 64 2c 20 |name spe|cified, |
|00003410| 61 6e 64 20 77 61 6e 74 | 73 20 74 6f 20 70 75 74 |and want|s to put|
|00003420| 20 70 69 76 6f 74 20 74 | 61 62 6c 65 20 69 6e 20 | pivot t|able in |
|00003430| 61 20 66 6f 72 6d 2c 20 | 73 6f 20 66 61 69 6c 0d |a form, |so fail.|
|00003440| 0a 09 54 48 49 53 2e 41 | 4c 45 52 54 28 45 5f 4e |..THIS.A|LERT(E_N|
|00003450| 4f 46 4f 52 4d 5f 4c 4f | 43 29 0d 0a 09 52 45 54 |OFORM_LO|C)...RET|
|00003460| 55 52 4e 0d 0a 45 4e 44 | 49 46 0d 0a 0d 0a 2a 20 |URN..END|IF....* |
|00003470| 43 68 65 63 6b 20 66 6f | 72 20 70 6f 74 65 6e 74 |Check fo|r potent|
|00003480| 69 61 6c 6c 79 20 6c 61 | 72 67 65 20 50 69 76 6f |ially la|rge Pivo|
|00003490| 74 54 61 62 6c 65 20 61 | 6e 64 20 77 61 72 6e 20 |tTable a|nd warn |
|000034a0| 75 73 65 72 0d 0a 49 46 | 20 52 45 43 43 4f 55 4e |user..IF| RECCOUN|
|000034b0| 54 28 29 20 3e 20 4d 41 | 58 5f 52 45 43 4f 52 44 |T() > MA|X_RECORD|
|000034c0| 53 0d 0a 0d 0a 09 4c 4f | 43 41 4c 20 61 54 6d 70 |S.....LO|CAL aTmp|
|000034d0| 41 72 72 2c 6e 50 61 67 | 65 43 6e 74 2c 6e 43 6f |Arr,nPag|eCnt,nCo|
|000034e0| 6c 43 6e 74 2c 6e 52 6f | 77 43 6e 74 2c 6e 53 61 |lCnt,nRo|wCnt,nSa|
|000034f0| 76 65 41 72 65 61 0d 0a | 09 44 49 4d 45 4e 53 49 |veArea..|.DIMENSI|
|00003500| 4f 4e 20 61 54 6d 70 41 | 72 72 5b 31 5d 0d 0a 09 |ON aTmpA|rr[1]...|
|00003510| 53 54 4f 52 45 20 31 20 | 54 4f 20 6e 50 61 67 65 |STORE 1 |TO nPage|
|00003520| 43 6e 74 2c 6e 43 6f 6c | 43 6e 74 2c 6e 52 6f 77 |Cnt,nCol|Cnt,nRow|
|00003530| 43 6e 74 0d 0a 09 6e 53 | 61 76 65 41 72 65 61 20 |Cnt...nS|aveArea |
|00003540| 3d 20 53 45 4c 45 43 54 | 28 29 09 0d 0a 09 49 46 |= SELECT|()....IF|
|00003550| 20 21 45 4d 50 54 59 28 | 54 48 49 53 2e 63 50 69 | !EMPTY(|THIS.cPi|
|00003560| 76 46 6c 64 52 6f 77 29 | 0d 0a 09 09 53 45 4c 45 |vFldRow)|....SELE|
|00003570| 43 54 20 44 49 53 54 49 | 4e 43 54 20 45 56 41 4c |CT DISTI|NCT EVAL|
|00003580| 28 54 48 49 53 2e 63 50 | 69 76 46 6c 64 52 6f 77 |(THIS.cP|ivFldRow|
|00003590| 29 20 46 52 4f 4d 20 28 | 41 4c 49 41 53 28 29 29 |) FROM (|ALIAS())|
|000035a0| 20 49 4e 54 4f 20 41 52 | 52 41 59 20 61 54 6d 70 | INTO AR|RAY aTmp|
|000035b0| 41 72 72 0d 0a 09 09 6d | 2e 6e 52 6f 77 43 6e 74 |Arr....m|.nRowCnt|
|000035c0| 20 3d 20 5f 54 41 4c 4c | 59 0d 0a 09 45 4e 44 49 | = _TALL|Y...ENDI|
|000035d0| 46 0d 0a 0d 0a 09 49 46 | 20 6d 2e 6e 52 6f 77 43 |F.....IF| m.nRowC|
|000035e0| 6e 74 20 3c 20 4d 41 58 | 5f 50 49 56 52 4f 57 53 |nt < MAX|_PIVROWS|
|000035f0| 0d 0a 09 09 49 46 20 21 | 45 4d 50 54 59 28 54 48 |....IF !|EMPTY(TH|
|00003600| 49 53 2e 63 50 69 76 46 | 6c 64 43 6f 6c 29 20 0d |IS.cPivF|ldCol) .|
|00003610| 0a 09 09 09 53 45 4c 45 | 43 54 20 44 49 53 54 49 |....SELE|CT DISTI|
|00003620| 4e 43 54 20 45 56 41 4c | 28 54 48 49 53 2e 63 50 |NCT EVAL|(THIS.cP|
|00003630| 69 76 46 6c 64 43 6f 6c | 29 20 46 52 4f 4d 20 28 |ivFldCol|) FROM (|
|00003640| 41 4c 49 41 53 28 29 29 | 20 49 4e 54 4f 20 41 52 |ALIAS())| INTO AR|
|00003650| 52 41 59 20 61 54 6d 70 | 41 72 72 0d 0a 09 09 09 |RAY aTmp|Arr.....|
|00003660| 6d 2e 6e 43 6f 6c 43 6e | 74 20 3d 20 5f 54 41 4c |m.nColCn|t = _TAL|
|00003670| 4c 59 0d 0a 09 09 45 4e | 44 49 46 0d 0a 09 09 49 |LY....EN|DIF....I|
|00003680| 46 20 6d 2e 6e 43 6f 6c | 43 6e 74 20 3c 20 4d 41 |F m.nCol|Cnt < MA|
|00003690| 58 5f 50 49 56 43 4f 4c | 53 0d 0a 09 09 09 49 46 |X_PIVCOL|S.....IF|
|000036a0| 20 21 45 4d 50 54 59 28 | 54 48 49 53 2e 63 50 69 | !EMPTY(|THIS.cPi|
|000036b0| 76 46 6c 64 50 61 67 65 | 29 0d 0a 09 09 09 09 53 |vFldPage|)......S|
|000036c0| 45 4c 45 43 54 20 44 49 | 53 54 49 4e 43 54 20 45 |ELECT DI|STINCT E|
|000036d0| 56 41 4c 28 54 48 49 53 | 2e 63 50 69 76 46 6c 64 |VAL(THIS|.cPivFld|
|000036e0| 50 61 67 65 29 20 46 52 | 4f 4d 20 28 41 4c 49 41 |Page) FR|OM (ALIA|
|000036f0| 53 28 29 29 20 49 4e 54 | 4f 20 41 52 52 41 59 20 |S()) INT|O ARRAY |
|00003700| 61 54 6d 70 41 72 72 0d | 0a 09 09 09 09 6d 2e 6e |aTmpArr.|.....m.n|
|00003710| 50 61 67 65 43 6e 74 20 | 3d 20 5f 54 41 4c 4c 59 |PageCnt |= _TALLY|
|00003720| 0d 0a 09 09 09 45 4e 44 | 49 46 0d 0a 09 09 45 4e |.....END|IF....EN|
|00003730| 44 49 46 0d 0a 09 45 4e | 44 49 46 0d 0a 09 0d 0a |DIF...EN|DIF.....|
|00003740| 09 49 46 20 53 45 4c 45 | 43 54 28 29 20 23 20 6d |.IF SELE|CT() # m|
|00003750| 2e 6e 53 61 76 65 41 72 | 65 61 0d 0a 09 09 53 45 |.nSaveAr|ea....SE|
|00003760| 4c 45 43 54 20 28 6d 2e | 6e 53 61 76 65 41 72 65 |LECT (m.|nSaveAre|
|00003770| 61 29 0d 0a 09 45 4e 44 | 49 46 0d 0a 0d 0a 09 49 |a)...END|IF.....I|
|00003780| 46 09 6d 2e 6e 52 6f 77 | 43 6e 74 20 3e 3d 20 4d |F.m.nRow|Cnt >= M|
|00003790| 41 58 5f 50 49 56 52 4f | 57 53 09 4f 52 3b 0d 0a |AX_PIVRO|WS.OR;..|
|000037a0| 09 09 6d 2e 6e 43 6f 6c | 43 6e 74 20 3e 3d 20 4d |..m.nCol|Cnt >= M|
|000037b0| 41 58 5f 50 49 56 43 4f | 4c 53 09 4f 52 3b 0d 0a |AX_PIVCO|LS.OR;..|
|000037c0| 09 09 6d 2e 6e 50 61 67 | 65 43 6e 74 20 3e 3d 20 |..m.nPag|eCnt >= |
|000037d0| 4d 41 58 5f 50 49 56 50 | 41 47 45 53 09 4f 52 3b |MAX_PIVP|AGES.OR;|
|000037e0| 0d 0a 09 09 6d 2e 6e 52 | 6f 77 43 6e 74 2a 6d 2e |....m.nR|owCnt*m.|
|000037f0| 6e 43 6f 6c 43 6e 74 2a | 6d 2e 6e 50 61 67 65 43 |nColCnt*|m.nPageC|
|00003800| 6e 74 20 3e 20 4d 41 58 | 5f 50 49 56 43 45 4c 4c |nt > MAX|_PIVCELL|
|00003810| 53 0d 0a 09 09 49 46 20 | 54 48 49 53 2e 41 4c 45 |S....IF |THIS.ALE|
|00003820| 52 54 28 43 5f 4c 41 52 | 47 45 50 49 56 4f 54 5f |RT(C_LAR|GEPIVOT_|
|00003830| 4c 4f 43 2c 33 36 29 20 | 23 20 22 59 45 53 22 0d |LOC,36) |# "YES".|
|00003840| 0a 09 09 09 52 45 54 55 | 52 4e 0d 0a 09 09 45 4e |....RETU|RN....EN|
|00003850| 44 49 46 0d 0a 09 45 4e | 44 49 46 09 0d 0a 45 4e |DIF...EN|DIF...EN|
|00003860| 44 49 46 0d 0a 0d 0a 2a | 20 43 68 65 63 6b 20 66 |DIF....*| Check f|
|00003870| 6f 72 20 4c 6f 6e 67 20 | 46 69 6c 65 20 4e 61 6d |or Long |File Nam|
|00003880| 65 73 0d 0a 49 46 20 43 | 55 52 53 4f 52 47 45 54 |es..IF C|URSORGET|
|00003890| 50 52 4f 50 28 27 73 6f | 75 72 63 65 74 79 70 65 |PROP('so|urcetype|
|000038a0| 27 29 3d 33 0d 0a 09 63 | 54 6d 70 4e 61 6d 65 20 |')=3...c|TmpName |
|000038b0| 3d 20 54 48 49 53 2e 47 | 65 74 44 4f 53 4e 61 6d |= THIS.G|etDOSNam|
|000038c0| 65 28 44 42 46 28 29 2c | 2e 54 2e 29 0d 0a 09 49 |e(DBF(),|.T.)...I|
|000038d0| 46 20 6d 2e 63 54 6d 70 | 4e 61 6d 65 20 23 20 44 |F m.cTmp|Name # D|
|000038e0| 42 46 28 29 20 4f 52 3b | 0d 0a 09 09 20 4c 45 4e |BF() OR;|.... LEN|
|000038f0| 28 54 48 49 53 2e 4a 75 | 73 74 46 6e 61 6d 65 28 |(THIS.Ju|stFname(|
|00003900| 44 42 46 28 29 29 29 3e | 31 32 20 4f 52 3b 0d 0a |DBF()))>|12 OR;..|
|00003910| 09 09 20 4c 45 4e 28 54 | 48 49 53 2e 4a 75 73 74 |.. LEN(T|HIS.Just|
|00003920| 53 74 65 6d 28 44 42 46 | 28 29 29 29 3e 38 0d 0a |Stem(DBF|()))>8..|
|00003930| 09 09 2a 20 4d 53 20 51 | 55 45 52 59 20 33 32 20 |..* MS Q|UERY 32 |
|00003940| 73 75 70 70 6f 72 74 73 | 20 6c 6f 6e 67 20 66 69 |supports| long fi|
|00003950| 6c 65 73 0d 0a 09 09 49 | 46 20 21 54 48 49 53 2e |les....I|F !THIS.|
|00003960| 6c 48 61 73 4d 53 51 52 | 59 33 32 20 0d 0a 09 09 |lHasMSQR|Y32 ....|
|00003970| 09 49 46 20 54 48 49 53 | 2e 41 4c 45 52 54 28 43 |.IF THIS|.ALERT(C|
|00003980| 5f 4c 4f 4e 47 46 4e 41 | 4d 45 5f 4c 4f 43 2c 33 |_LONGFNA|ME_LOC,3|
|00003990| 36 29 3d 22 59 45 53 22 | 0d 0a 09 09 09 09 6c 63 |6)="YES"|......lc|
|000039a0| 6f 70 79 66 69 6c 65 20 | 3d 20 2e 54 2e 0d 0a 09 |opyfile |= .T....|
|000039b0| 09 09 45 4c 53 45 0d 0a | 09 09 09 09 52 45 54 55 |..ELSE..|....RETU|
|000039c0| 52 4e 0d 0a 09 09 09 45 | 4e 44 49 46 09 0d 0a 09 |RN.....E|NDIF....|
|000039d0| 09 45 4e 44 49 46 0d 0a | 09 45 4e 44 49 46 0d 0a |.ENDIF..|.ENDIF..|
|000039e0| 45 4e 44 49 46 0d 0a 0d | 0a 54 48 49 53 2e 63 44 |ENDIF...|.THIS.cD|
|000039f0| 42 43 41 6c 69 61 73 20 | 3d 20 54 48 49 53 2e 47 |BCAlias |= THIS.G|
|00003a00| 65 74 44 42 43 41 6c 69 | 61 73 28 54 48 49 53 2e |etDBCAli|as(THIS.|
|00003a10| 63 44 42 43 4e 61 6d 65 | 29 0d 0a 0d 0a 2a 2d 20 |cDBCName|)....*- |
|00003a20| 43 68 65 63 6b 20 69 66 | 20 44 42 43 20 69 73 20 |Check if| DBC is |
|00003a30| 6f 70 65 6e 65 64 20 65 | 78 63 6c 75 73 69 76 65 |opened e|xclusive|
|00003a40| 6c 79 0d 0a 49 46 20 54 | 48 49 53 2e 6c 48 61 73 |ly..IF T|HIS.lHas|
|00003a50| 33 30 44 72 69 76 65 72 | 73 20 41 4e 44 20 21 45 |30Driver|s AND !E|
|00003a60| 4d 50 54 59 28 54 48 49 | 53 2e 63 44 42 43 41 6c |MPTY(THI|S.cDBCAl|
|00003a70| 69 61 73 29 20 41 4e 44 | 20 49 53 45 58 43 4c 28 |ias) AND| ISEXCL(|
|00003a80| 54 48 49 53 2e 63 44 42 | 43 41 6c 69 61 73 2c 32 |THIS.cDB|CAlias,2|
|00003a90| 29 0d 0a 09 49 46 20 4d | 45 53 53 41 47 45 42 4f |)...IF M|ESSAGEBO|
|00003aa0| 58 28 43 5f 45 58 43 4c | 44 42 43 31 5f 4c 4f 43 |X(C_EXCL|DBC1_LOC|
|00003ab0| 2b 54 48 49 53 2e 63 44 | 42 43 41 6c 69 61 73 2b |+THIS.cD|BCAlias+|
|00003ac0| 43 5f 45 58 43 4c 44 42 | 43 32 5f 4c 4f 43 2c 33 |C_EXCLDB|C2_LOC,3|
|00003ad0| 36 29 20 3d 3d 20 36 0d | 0a 09 09 63 54 6d 70 44 |6) == 6.|...cTmpD|
|00003ae0| 62 63 41 6c 69 61 73 20 | 3d 20 54 48 49 53 2e 63 |bcAlias |= THIS.c|
|00003af0| 44 42 43 41 6c 69 61 73 | 0d 0a 09 09 53 45 54 20 |DBCAlias|....SET |
|00003b00| 44 41 54 41 42 41 53 45 | 20 54 4f 20 28 6d 2e 63 |DATABASE| TO (m.c|
|00003b10| 54 6d 70 44 62 63 41 6c | 69 61 73 29 0d 0a 09 09 |TmpDbcAl|ias)....|
|00003b20| 43 4c 4f 53 45 20 44 41 | 54 41 42 41 53 45 20 0d |CLOSE DA|TABASE .|
|00003b30| 0a 09 09 4f 50 45 4e 20 | 44 41 54 41 42 41 53 45 |...OPEN |DATABASE|
|00003b40| 20 28 54 48 49 53 2e 63 | 44 42 43 4e 61 6d 65 29 | (THIS.c|DBCName)|
|00003b50| 20 53 48 41 52 45 44 0d | 0a 09 09 55 53 45 20 28 | SHARED.|...USE (|
|00003b60| 54 48 49 53 2e 63 44 42 | 43 54 61 62 6c 65 29 20 |THIS.cDB|CTable) |
|00003b70| 41 4c 49 41 53 20 28 54 | 48 49 53 2e 63 41 6c 69 |ALIAS (T|HIS.cAli|
|00003b80| 61 73 29 20 53 48 41 52 | 45 44 0d 0a 09 45 4c 53 |as) SHAR|ED...ELS|
|00003b90| 45 0d 0a 09 09 52 45 54 | 55 52 4e 0d 0a 09 45 4e |E....RET|URN...EN|
|00003ba0| 44 49 46 0d 0a 45 4e 44 | 49 46 0d 0a 0d 0a 2a 20 |DIF..END|IF....* |
|00003bb0| 43 68 65 63 6b 20 66 6f | 72 20 33 2e 30 20 54 61 |Check fo|r 3.0 Ta|
|00003bc0| 62 6c 65 20 74 79 70 65 | 20 4f 52 20 56 69 65 77 |ble type| OR View|
|00003bd0| 0d 0a 49 46 20 21 6d 2e | 6c 63 6f 70 79 66 69 6c |..IF !m.|lcopyfil|
|00003be0| 65 20 41 4e 44 20 21 54 | 48 49 53 2e 6c 48 61 73 |e AND !T|HIS.lHas|
|00003bf0| 33 30 44 72 69 76 65 72 | 73 20 41 4e 44 3b 0d 0a |30Driver|s AND;..|
|00003c00| 09 28 56 41 4c 28 53 59 | 53 28 32 30 32 39 29 29 |.(VAL(SY|S(2029))|
|00003c10| 3d 44 42 46 54 59 50 45 | 5f 33 30 20 4f 52 20 43 |=DBFTYPE|_30 OR C|
|00003c20| 55 52 53 4f 52 47 45 54 | 50 52 4f 50 28 27 73 6f |URSORGET|PROP('so|
|00003c30| 75 72 63 65 74 79 70 65 | 27 29 23 33 29 0d 0a 09 |urcetype|')#3)...|
|00003c40| 49 46 20 54 48 49 53 2e | 41 4c 45 52 54 28 43 5f |IF THIS.|ALERT(C_|
|00003c50| 43 4f 50 59 46 4f 58 32 | 5f 4c 4f 43 2c 33 36 29 |COPYFOX2|_LOC,36)|
|00003c60| 3d 22 59 45 53 22 0d 0a | 09 09 6c 63 6f 70 79 66 |="YES"..|..lcopyf|
|00003c70| 69 6c 65 20 3d 20 2e 54 | 2e 0d 0a 09 45 4c 53 45 |ile = .T|....ELSE|
|00003c80| 0d 0a 09 09 52 45 54 55 | 52 4e 0d 0a 09 45 4e 44 |....RETU|RN...END|
|00003c90| 49 46 0d 0a 45 4e 44 49 | 46 0d 0a 0d 0a 2a 2d 20 |IF..ENDI|F....*- |
|00003ca0| 43 6f 70 79 20 66 69 6c | 65 0d 0a 49 46 20 6d 2e |Copy fil|e..IF m.|
|00003cb0| 6c 63 6f 70 79 66 69 6c | 65 09 09 0d 0a 09 2a 20 |lcopyfil|e.....* |
|00003cc0| 55 6e 74 69 6c 20 33 2e | 30 20 64 72 69 76 65 72 |Until 3.|0 driver|
|00003cd0| 73 20 63 6f 6d 65 20 6f | 75 74 2c 20 61 73 6b 20 |s come o|ut, ask |
|00003ce0| 69 66 20 74 68 65 79 20 | 77 61 6e 74 20 74 6f 20 |if they |want to |
|00003cf0| 63 6f 70 79 20 66 69 6c | 65 0d 0a 09 4c 4f 43 41 |copy fil|e...LOCA|
|00003d00| 4c 20 6d 2e 63 53 61 76 | 65 46 69 6c 65 0d 0a 09 |L m.cSav|eFile...|
|00003d10| 09 0d 0a 09 49 46 20 43 | 55 52 53 4f 52 47 45 54 |....IF C|URSORGET|
|00003d20| 50 52 4f 50 28 27 73 6f | 75 72 63 65 74 79 70 65 |PROP('so|urcetype|
|00003d30| 27 29 23 33 20 26 26 20 | 4f 52 20 41 54 43 28 22 |')#3 && |OR ATC("|
|00003d40| 2e 54 4d 50 22 2c 44 42 | 46 28 29 29 23 30 0d 0a |.TMP",DB|F())#0..|
|00003d50| 09 09 63 53 61 76 65 46 | 69 6c 65 20 3d 20 43 75 |..cSaveF|ile = Cu|
|00003d60| 72 73 6f 72 47 65 74 70 | 72 6f 70 28 22 73 6f 75 |rsorGetp|rop("sou|
|00003d70| 72 63 65 6e 61 6d 65 22 | 29 0d 0a 09 45 4c 53 45 |rcename"|)...ELSE|
|00003d80| 0d 0a 09 09 63 53 61 76 | 65 46 69 6c 65 20 3d 20 |....cSav|eFile = |
|00003d90| 54 48 49 53 2e 4a 75 73 | 74 53 74 65 6d 28 44 42 |THIS.Jus|tStem(DB|
|00003da0| 46 28 29 29 0d 0a 09 45 | 4e 44 49 46 0d 0a 0d 0a |F())...E|NDIF....|
|00003db0| 09 2a 2d 20 4d 53 20 51 | 75 65 72 79 20 31 2e 30 |.*- MS Q|uery 1.0|
|00003dc0| 20 64 6f 65 73 20 6e 6f | 74 20 73 75 70 70 6f 72 | does no|t suppor|
|00003dd0| 74 20 6c 6f 6e 67 20 66 | 69 6c 65 20 6e 61 6d 65 |t long f|ile name|
|00003de0| 73 2e 0d 0a 09 44 4f 20 | 43 41 53 45 0d 0a 09 09 |s....DO |CASE....|
|00003df0| 43 41 53 45 20 4c 45 4e | 28 6d 2e 63 53 61 76 65 |CASE LEN|(m.cSave|
|00003e00| 46 69 6c 65 29 20 3c 20 | 38 0d 0a 09 09 09 63 53 |File) < |8.....cS|
|00003e10| 61 76 65 46 69 6c 65 20 | 3d 20 6d 2e 63 53 61 76 |aveFile |= m.cSav|
|00003e20| 65 46 69 6c 65 20 2b 20 | 22 32 22 0d 0a 09 09 43 |eFile + |"2"....C|
|00003e30| 41 53 45 20 4c 45 4e 28 | 6d 2e 63 53 61 76 65 46 |ASE LEN(|m.cSaveF|
|00003e40| 69 6c 65 29 20 3d 20 38 | 20 41 4e 44 20 52 49 47 |ile) = 8| AND RIG|
|00003e50| 48 54 28 6d 2e 63 53 61 | 76 65 46 69 6c 65 2c 31 |HT(m.cSa|veFile,1|
|00003e60| 29 20 3d 20 22 32 22 0d | 0a 09 09 09 63 53 61 76 |) = "2".|....cSav|
|00003e70| 65 46 69 6c 65 20 3d 20 | 4c 45 46 54 28 6d 2e 63 |eFile = |LEFT(m.c|
|00003e80| 53 61 76 65 46 69 6c 65 | 2c 37 29 20 2b 20 22 5f |SaveFile|,7) + "_|
|00003e90| 22 0d 0a 09 09 4f 54 48 | 45 52 57 49 53 45 0d 0a |"....OTH|ERWISE..|
|00003ea0| 09 09 09 63 53 61 76 65 | 46 69 6c 65 20 3d 20 4c |...cSave|File = L|
|00003eb0| 45 46 54 28 6d 2e 63 53 | 61 76 65 46 69 6c 65 2c |EFT(m.cS|aveFile,|
|00003ec0| 37 29 20 2b 20 22 32 22 | 0d 0a 09 45 4e 44 43 41 |7) + "2"|...ENDCA|
|00003ed0| 53 45 0d 0a 09 09 0d 0a | 09 2a 2d 20 53 69 6e 63 |SE......|.*- Sinc|
|00003ee0| 65 20 4d 53 20 51 75 65 | 72 79 20 64 6f 65 73 20 |e MS Que|ry does |
|00003ef0| 6e 6f 74 20 73 75 70 70 | 6f 72 74 20 6e 6f 6e 20 |not supp|ort non |
|00003f00| 44 4f 53 20 66 69 6c 65 | 6e 61 6d 65 73 2c 20 77 |DOS file|names, w|
|00003f10| 65 20 6e 65 65 64 20 74 | 6f 20 63 68 65 63 6b 20 |e need t|o check |
|00003f20| 68 65 72 65 2e 0d 0a 09 | 63 53 61 76 65 46 69 6c |here....|cSaveFil|
|00003f30| 65 20 3d 20 54 48 49 53 | 2e 47 65 74 44 4f 53 4e |e = THIS|.GetDOSN|
|00003f40| 61 6d 65 28 6d 2e 63 53 | 61 76 65 46 69 6c 65 29 |ame(m.cS|aveFile)|
|00003f50| 0d 0a 09 44 4f 20 57 48 | 49 4c 45 20 2e 54 2e 0d |...DO WH|ILE .T..|
|00003f60| 0a 09 09 63 53 61 76 65 | 46 69 6c 65 20 3d 20 50 |...cSave|File = P|
|00003f70| 55 54 46 49 4c 45 28 43 | 5f 43 4f 50 59 50 52 4f |UTFILE(C|_COPYPRO|
|00003f80| 4d 50 54 5f 4c 4f 43 2c | 6d 2e 63 53 61 76 65 46 |MPT_LOC,|m.cSaveF|
|00003f90| 69 6c 65 2b 22 2e 64 62 | 66 22 2c 22 44 42 46 22 |ile+".db|f","DBF"|
|00003fa0| 29 0d 0a 09 09 49 46 20 | 45 4d 50 54 59 28 6d 2e |)....IF |EMPTY(m.|
|00003fb0| 63 53 61 76 65 46 69 6c | 65 29 0d 0a 09 09 09 52 |cSaveFil|e).....R|
|00003fc0| 45 54 55 52 4e 0d 0a 09 | 09 45 4e 44 49 46 0d 0a |ETURN...|.ENDIF..|
|00003fd0| 09 09 0d 0a 09 09 2a 20 | 52 65 63 68 65 63 6b 20 |......* |Recheck |
|00003fe0| 74 6f 20 6d 61 6b 65 20 | 73 75 72 65 20 69 6e 76 |to make |sure inv|
|00003ff0| 61 6c 69 64 20 63 68 61 | 72 61 63 74 65 72 20 77 |alid cha|racter w|
|00004000| 61 73 20 6e 6f 74 20 65 | 6e 74 65 72 65 64 0d 0a |as not e|ntered..|
|00004010| 09 09 63 53 61 76 65 46 | 69 6c 65 20 3d 20 54 48 |..cSaveF|ile = TH|
|00004020| 49 53 2e 46 6f 72 63 65 | 45 78 74 28 6d 2e 63 53 |IS.Force|Ext(m.cS|
|00004030| 61 76 65 46 69 6c 65 2c | 22 44 42 46 22 29 0d 0a |aveFile,|"DBF")..|
|00004040| 09 09 63 54 6d 70 4e 61 | 6d 65 20 3d 20 54 48 49 |..cTmpNa|me = THI|
|00004050| 53 2e 47 65 74 44 4f 53 | 4e 61 6d 65 28 6d 2e 63 |S.GetDOS|Name(m.c|
|00004060| 53 61 76 65 46 69 6c 65 | 2c 2e 54 2e 29 0d 0a 09 |SaveFile|,.T.)...|
|00004070| 09 49 46 20 6d 2e 63 54 | 6d 70 4e 61 6d 65 20 23 |.IF m.cT|mpName #|
|00004080| 20 6d 2e 63 53 61 76 65 | 46 69 6c 65 20 4f 52 3b | m.cSave|File OR;|
|00004090| 0d 0a 09 09 09 20 4c 45 | 4e 28 54 48 49 53 2e 4a |..... LE|N(THIS.J|
|000040a0| 75 73 74 46 6e 61 6d 65 | 28 6d 2e 63 53 61 76 65 |ustFname|(m.cSave|
|000040b0| 46 69 6c 65 29 29 3e 31 | 32 20 4f 52 3b 0d 0a 09 |File))>1|2 OR;...|
|000040c0| 09 09 20 4c 45 4e 28 54 | 48 49 53 2e 4a 75 73 74 |.. LEN(T|HIS.Just|
|000040d0| 53 74 65 6d 28 6d 2e 63 | 53 61 76 65 46 69 6c 65 |Stem(m.c|SaveFile|
|000040e0| 29 29 3e 38 0d 0a 09 09 | 09 49 46 20 54 48 49 53 |))>8....|.IF THIS|
|000040f0| 2e 41 4c 45 52 54 28 43 | 5f 4c 4f 4e 47 46 4e 41 |.ALERT(C|_LONGFNA|
|00004100| 4d 45 5f 4c 4f 43 2c 33 | 36 29 23 22 59 45 53 22 |ME_LOC,3|6)#"YES"|
|00004110| 0d 0a 09 09 09 09 52 45 | 54 55 52 4e 0d 0a 09 09 |......RE|TURN....|
|00004120| 09 45 4e 44 49 46 0d 0a | 09 09 09 63 53 61 76 65 |.ENDIF..|...cSave|
|00004130| 46 69 6c 65 20 3d 20 54 | 48 49 53 2e 4a 75 73 74 |File = T|HIS.Just|
|00004140| 53 74 65 6d 28 6d 2e 63 | 53 61 76 65 46 69 6c 65 |Stem(m.c|SaveFile|
|00004150| 29 0d 0a 09 09 45 4c 53 | 45 0d 0a 09 09 09 45 58 |)....ELS|E.....EX|
|00004160| 49 54 09 0d 0a 09 09 45 | 4e 44 49 46 0d 0a 09 45 |IT.....E|NDIF...E|
|00004170| 4e 44 44 4f 0d 0a 0d 0a | 09 43 4f 50 59 20 54 4f |NDDO....|.COPY TO|
|00004180| 20 28 6d 2e 63 53 61 76 | 65 46 69 6c 65 29 20 54 | (m.cSav|eFile) T|
|00004190| 59 50 45 20 46 4f 58 32 | 0d 0a 09 0d 0a 09 2a 20 |YPE FOX2|......* |
|000041a0| 4e 65 65 64 20 74 6f 20 | 63 68 65 63 6b 20 69 66 |Need to |check if|
|000041b0| 20 63 6f 70 69 65 64 20 | 4f 4b 0d 0a 09 49 46 20 | copied |OK...IF |
|000041c0| 21 46 49 4c 45 28 6d 2e | 63 53 61 76 65 46 69 6c |!FILE(m.|cSaveFil|
|000041d0| 65 29 0d 0a 09 09 52 45 | 54 55 52 4e 0d 0a 09 45 |e)....RE|TURN...E|
|000041e0| 4e 44 49 46 0d 0a 09 53 | 45 4c 45 43 54 20 30 0d |NDIF...S|ELECT 0.|
|000041f0| 0a 09 55 53 45 20 28 6d | 2e 63 53 61 76 65 46 69 |..USE (m|.cSaveFi|
|00004200| 6c 65 29 20 53 48 41 52 | 45 44 0d 0a 09 0d 0a 09 |le) SHAR|ED......|
|00004210| 2a 20 46 61 69 6c 65 64 | 20 73 6f 6d 65 77 68 65 |* Failed| somewhe|
|00004220| 72 65 0d 0a 09 49 46 20 | 45 4d 50 54 59 28 41 4c |re...IF |EMPTY(AL|
|00004230| 49 41 53 28 29 29 20 4f | 52 20 56 41 4c 28 53 59 |IAS()) O|R VAL(SY|
|00004240| 53 28 32 30 32 39 29 29 | 3d 44 42 46 54 59 50 45 |S(2029))|=DBFTYPE|
|00004250| 5f 33 30 0d 0a 09 09 52 | 45 54 55 52 4e 0d 0a 09 |_30....R|ETURN...|
|00004260| 45 4e 44 49 46 0d 0a 09 | 54 48 49 53 2e 63 41 6c |ENDIF...|THIS.cAl|
|00004270| 69 61 73 20 3d 20 41 4c | 49 41 53 28 29 0d 0a 09 |ias = AL|IAS()...|
|00004280| 0d 0a 09 2a 20 4e 65 65 | 64 20 74 6f 20 72 65 73 |...* Nee|d to res|
|00004290| 65 74 20 66 69 65 6c 64 | 20 6e 61 6d 65 73 20 74 |et field| names t|
|000042a0| 6f 20 3c 3d 20 31 30 20 | 63 68 61 72 73 20 73 69 |o <= 10 |chars si|
|000042b0| 6e 63 65 0d 0a 09 2a 20 | 46 4f 58 32 20 74 61 62 |nce...* |FOX2 tab|
|000042c0| 6c 65 73 20 6f 6e 6c 79 | 20 73 75 70 70 6f 72 74 |les only| support|
|000042d0| 20 66 69 65 6c 64 20 6e | 61 6d 65 73 20 6f 66 20 | field n|ames of |
|000042e0| 74 68 69 73 20 6c 65 6e | 67 74 68 2e 0d 0a 09 09 |this len|gth.....|
|000042f0| 0d 0a 09 54 48 49 53 2e | 63 50 69 76 46 6c 64 44 |...THIS.|cPivFldD|
|00004300| 61 74 61 20 3d 20 54 48 | 49 53 2e 43 68 65 63 6b |ata = TH|IS.Check|
|00004310| 46 6c 64 4c 65 6e 28 54 | 48 49 53 2e 63 50 69 76 |FldLen(T|HIS.cPiv|
|00004320| 46 6c 64 44 61 74 61 29 | 09 26 26 20 50 69 76 6f |FldData)|.&& Pivo|
|00004330| 74 20 64 61 74 61 20 66 | 69 65 6c 64 0d 0a 09 54 |t data f|ield...T|
|00004340| 48 49 53 2e 63 50 69 76 | 46 6c 64 50 61 67 65 20 |HIS.cPiv|FldPage |
|00004350| 3d 20 54 48 49 53 2e 43 | 68 65 63 6b 46 6c 64 4c |= THIS.C|heckFldL|
|00004360| 65 6e 28 54 48 49 53 2e | 63 50 69 76 46 6c 64 50 |en(THIS.|cPivFldP|
|00004370| 61 67 65 29 09 26 26 20 | 50 69 76 6f 74 20 70 61 |age).&& |Pivot pa|
|00004380| 67 65 20 66 69 65 6c 64 | 0d 0a 09 54 48 49 53 2e |ge field|...THIS.|
|00004390| 63 50 69 76 46 6c 64 52 | 6f 77 20 3d 20 54 48 49 |cPivFldR|ow = THI|
|000043a0| 53 2e 43 68 65 63 6b 46 | 6c 64 4c 65 6e 28 54 48 |S.CheckF|ldLen(TH|
|000043b0| 49 53 2e 63 50 69 76 46 | 6c 64 52 6f 77 29 09 09 |IS.cPivF|ldRow)..|
|000043c0| 26 26 20 50 69 76 6f 74 | 20 72 6f 77 20 66 69 65 |&& Pivot| row fie|
|000043d0| 6c 64 0d 0a 09 54 48 49 | 53 2e 63 50 69 76 46 6c |ld...THI|S.cPivFl|
|000043e0| 64 43 6f 6c 20 3d 20 54 | 48 49 53 2e 43 68 65 63 |dCol = T|HIS.Chec|
|000043f0| 6b 46 6c 64 4c 65 6e 28 | 54 48 49 53 2e 63 50 69 |kFldLen(|THIS.cPi|
|00004400| 76 46 6c 64 43 6f 6c 29 | 09 09 26 26 20 50 69 76 |vFldCol)|..&& Piv|
|00004410| 6f 74 20 63 6f 6c 75 6d | 6e 20 66 69 65 6c 64 0d |ot colum|n field.|
|00004420| 0a 09 0d 0a 45 4e 44 49 | 46 0d 0a 0d 0a 0d 0a 2a |....ENDI|F......*|
|00004430| 2d 20 43 68 65 63 6b 20 | 74 6f 20 6d 61 6b 65 20 |- Check |to make |
|00004440| 73 75 72 65 20 77 65 20 | 68 61 76 65 20 73 68 61 |sure we |have sha|
|00004450| 72 65 64 20 75 73 65 20 | 6f 66 20 66 69 6c 65 0d |red use |of file.|
|00004460| 0a 49 46 20 49 53 45 58 | 43 4c 55 53 49 56 45 28 |.IF ISEX|CLUSIVE(|
|00004470| 29 20 41 4e 44 20 43 55 | 52 53 4f 52 47 45 54 50 |) AND CU|RSORGETP|
|00004480| 52 4f 50 28 27 73 6f 75 | 72 63 65 74 79 70 65 27 |ROP('sou|rcetype'|
|00004490| 29 20 3d 3d 20 33 0d 0a | 09 6d 2e 63 54 68 69 73 |) == 3..|.m.cThis|
|000044a0| 44 42 46 20 3d 20 44 42 | 46 28 29 0d 0a 09 55 53 |DBF = DB|F()...US|
|000044b0| 45 20 28 6d 2e 63 54 68 | 69 73 44 42 46 29 20 53 |E (m.cTh|isDBF) S|
|000044c0| 48 41 52 45 44 0d 0a 09 | 49 46 20 45 4d 50 54 59 |HARED...|IF EMPTY|
|000044d0| 28 41 4c 49 41 53 28 29 | 29 20 4f 52 20 54 48 49 |(ALIAS()|) OR THI|
|000044e0| 53 2e 48 61 64 45 72 72 | 6f 72 0d 0a 09 09 52 45 |S.HadErr|or....RE|
|000044f0| 54 55 52 4e 0d 0a 09 45 | 4e 44 49 46 0d 0a 09 54 |TURN...E|NDIF...T|
|00004500| 48 49 53 2e 63 41 6c 69 | 61 73 20 3d 20 41 4c 49 |HIS.cAli|as = ALI|
|00004510| 41 53 28 29 0d 0a 45 4e | 44 49 46 0d 0a 0d 0a 2a |AS()..EN|DIF....*|
|00004520| 2d 20 53 65 65 20 69 66 | 20 45 78 63 65 6c 20 69 |- See if| Excel i|
|00004530| 73 20 61 6c 72 65 61 64 | 79 20 6f 70 65 6e 20 6f |s alread|y open o|
|00004540| 74 68 65 72 77 69 73 65 | 20 77 65 20 6e 65 65 64 |therwise| we need|
|00004550| 20 74 6f 20 73 74 61 72 | 74 20 69 74 2e 0d 0a 6d | to star|t it...m|
|00004560| 2e 6c 4f 6c 64 53 65 74 | 4f 70 74 20 3d 20 44 44 |.lOldSet|Opt = DD|
|00004570| 45 53 65 74 4f 70 74 69 | 6f 6e 28 22 53 41 46 45 |ESetOpti|on("SAFE|
|00004580| 54 59 22 29 0d 0a 3d 44 | 44 45 53 65 74 4f 70 74 |TY")..=D|DESetOpt|
|00004590| 69 6f 6e 28 22 53 41 46 | 45 54 59 22 2c 2e 46 2e |ion("SAF|ETY",.F.|
|000045a0| 29 0d 0a 6d 2e 73 79 73 | 63 68 3d 44 44 45 49 6e |)..m.sys|ch=DDEIn|
|000045b0| 69 74 69 61 74 65 28 22 | 45 78 63 65 6c 22 2c 22 |itiate("|Excel","|
|000045c0| 53 79 73 74 65 6d 22 29 | 0d 0a 49 46 20 6d 2e 73 |System")|..IF m.s|
|000045d0| 79 73 63 68 20 3d 20 2d | 31 09 26 26 66 61 69 6c |ysch = -|1.&&fail|
|000045e0| 65 64 09 0d 0a 09 54 48 | 49 53 2e 44 69 73 70 6c |ed....TH|IS.Displ|
|000045f0| 61 79 53 74 61 74 75 73 | 28 43 5f 53 54 41 52 54 |ayStatus|(C_START|
|00004600| 58 4c 5f 4c 4f 43 29 0d | 0a 09 78 6c 61 70 70 20 |XL_LOC).|..xlapp |
|00004610| 3d 20 43 72 65 61 74 65 | 4f 62 6a 65 63 74 28 4f |= Create|Object(O|
|00004620| 4c 45 5f 58 4c 41 50 50 | 29 0d 0a 45 4c 53 45 0d |LE_XLAPP|)..ELSE.|
|00004630| 0a 09 3d 44 44 45 54 65 | 72 6d 69 6e 61 74 65 28 |..=DDETe|rminate(|
|00004640| 6d 2e 73 79 73 63 68 29 | 0d 0a 09 78 6c 61 70 70 |m.sysch)|...xlapp|
|00004650| 20 3d 20 47 65 74 4f 62 | 6a 65 63 74 28 2c 4f 4c | = GetOb|ject(,OL|
|00004660| 45 5f 58 4c 41 50 50 29 | 0d 0a 45 4e 44 49 46 0d |E_XLAPP)|..ENDIF.|
|00004670| 0a 0d 0a 2a 2d 20 52 65 | 73 65 74 20 6f 72 69 67 |...*- Re|set orig|
|00004680| 69 6e 61 6c 20 73 74 61 | 74 65 0d 0a 3d 44 44 45 |inal sta|te..=DDE|
|00004690| 53 65 74 4f 70 74 69 6f | 6e 28 22 53 41 46 45 54 |SetOptio|n("SAFET|
|000046a0| 59 22 2c 6d 2e 6c 4f 6c | 64 53 65 74 4f 70 74 29 |Y",m.lOl|dSetOpt)|
|000046b0| 0d 0a 0d 0a 2a 2d 20 57 | 65 20 6e 65 65 64 20 74 |....*- W|e need t|
|000046c0| 6f 20 73 65 74 20 74 68 | 65 20 4c 6f 63 61 6c 69 |o set th|e Locali|
|000046d0| 7a 61 74 69 6f 6e 20 49 | 44 20 74 6f 20 65 6e 67 |zation I|D to eng|
|000046e0| 6c 69 73 68 20 28 31 30 | 33 33 29 0d 0a 2a 2d 20 |lish (10|33)..*- |
|000046f0| 73 6f 20 74 68 61 74 20 | 4f 4c 45 20 41 75 74 6f |so that |OLE Auto|
|00004700| 6d 61 74 69 6f 6e 20 77 | 69 6c 6c 20 62 65 20 75 |mation w|ill be u|
|00004710| 6e 64 65 72 73 74 6f 6f | 64 20 62 79 20 4f 4c 45 |nderstoo|d by OLE|
|00004720| 20 73 65 72 76 65 72 2e | 0d 0a 53 59 53 28 33 30 | server.|..SYS(30|
|00004730| 30 36 2c 31 30 33 33 29 | 0d 0a 0d 0a 2a 20 43 68 |06,1033)|....* Ch|
|00004740| 65 63 6b 20 69 66 20 70 | 72 6f 62 6c 65 6d 20 63 |eck if p|roblem c|
|00004750| 72 65 61 74 69 6e 67 20 | 45 78 63 65 6c 20 6f 62 |reating |Excel ob|
|00004760| 6a 65 63 74 0d 0a 49 46 | 20 54 59 50 45 28 27 78 |ject..IF| TYPE('x|
|00004770| 6c 61 70 70 27 29 20 23 | 20 27 4f 27 20 4f 52 20 |lapp') #| 'O' OR |
|00004780| 54 48 49 53 2e 48 61 64 | 65 72 72 6f 72 0d 0a 09 |THIS.Had|error...|
|00004790| 4d 45 53 53 41 47 45 42 | 4f 58 28 45 5f 46 41 49 |MESSAGEB|OX(E_FAI|
|000047a0| 4c 58 4c 5f 4c 4f 43 29 | 0d 0a 09 52 45 54 55 52 |LXL_LOC)|...RETUR|
|000047b0| 4e 0d 0a 45 4c 53 45 0d | 0a 09 2a 20 43 68 65 63 |N..ELSE.|..* Chec|
|000047c0| 6b 20 66 6f 72 20 67 6f | 6f 64 20 73 74 61 74 65 |k for go|od state|
|000047d0| 20 28 69 2e 65 2e 2c 20 | 6e 6f 20 6d 6f 64 61 6c | (i.e., |no modal|
|000047e0| 20 64 69 61 6c 6f 67 73 | 20 6f 70 65 6e 20 69 6e | dialogs| open in|
|000047f0| 20 45 78 63 65 6c 29 0d | 0a 09 54 48 49 53 2e 43 | Excel).|..THIS.C|
|00004800| 68 65 63 6b 53 74 61 74 | 65 20 3d 20 2e 54 2e 0d |heckStat|e = .T..|
|00004810| 0a 09 3d 78 6c 61 70 70 | 2e 63 61 70 74 69 6f 6e |..=xlapp|.caption|
|00004820| 0d 0a 09 49 46 20 54 48 | 49 53 2e 68 61 64 65 72 |...IF TH|IS.hader|
|00004830| 72 6f 72 0d 0a 09 09 52 | 45 54 55 52 4e 0d 0a 09 |ror....R|ETURN...|
|00004840| 45 4e 44 49 46 0d 0a 09 | 54 48 49 53 2e 43 68 65 |ENDIF...|THIS.Che|
|00004850| 63 6b 53 74 61 74 65 20 | 3d 20 2e 46 2e 0d 0a 45 |ckState |= .F...E|
|00004860| 4e 44 49 46 0d 0a 0d 0a | 44 4f 20 43 41 53 45 0d |NDIF....|DO CASE.|
|00004870| 0a 09 43 41 53 45 20 54 | 48 49 53 2e 6e 41 63 74 |..CASE T|HIS.nAct|
|00004880| 69 6f 6e 20 3d 20 31 09 | 26 26 45 78 63 65 6c 20 |ion = 1.|&&Excel |
|00004890| 50 69 76 6f 74 54 61 62 | 6c 65 0d 0a 09 09 2a 2d |PivotTab|le....*-|
|000048a0| 20 4d 61 6b 65 20 45 78 | 63 65 6c 20 76 69 73 69 | Make Ex|cel visi|
|000048b0| 62 6c 65 20 69 66 20 6e | 6f 74 20 61 6c 72 65 61 |ble if n|ot alrea|
|000048c0| 64 79 0d 0a 09 09 78 6c | 61 70 70 2e 76 69 73 69 |dy....xl|app.visi|
|000048d0| 62 6c 65 20 3d 20 2e 54 | 2e 0d 0a 09 09 2a 2d 20 |ble = .T|.....*- |
|000048e0| 43 72 65 61 74 65 20 6e | 65 77 20 77 6f 72 6b 62 |Create n|ew workb|
|000048f0| 6f 6f 6b 0d 0a 09 09 78 | 6c 61 70 70 2e 77 6f 72 |ook....x|lapp.wor|
|00004900| 6b 62 6f 6f 6b 73 2e 61 | 64 64 0d 0a 09 09 78 6c |kbooks.a|dd....xl|
|00004910| 61 63 74 69 76 65 73 68 | 65 65 74 20 3d 20 78 6c |activesh|eet = xl|
|00004920| 61 70 70 2e 61 63 74 69 | 76 65 73 68 65 65 74 0d |app.acti|vesheet.|
|00004930| 0a 09 09 0d 0a 09 43 41 | 53 45 20 54 48 49 53 2e |......CA|SE THIS.|
|00004940| 6e 41 63 74 69 6f 6e 20 | 3d 20 32 09 26 26 20 46 |nAction |= 2.&& F|
|00004950| 6f 78 50 72 6f 20 66 6f | 72 6d 20 77 69 74 68 20 |oxPro fo|rm with |
|00004960| 50 69 76 6f 74 54 61 62 | 6c 65 0d 0a 09 09 4c 4f |PivotTab|le....LO|
|00004970| 43 41 4c 20 63 46 6f 72 | 6d 53 43 58 2c 20 63 46 |CAL cFor|mSCX, cF|
|00004980| 6f 72 6d 4e 61 6d 65 0d | 0a 09 09 0d 0a 09 09 63 |ormName.|.......c|
|00004990| 46 6f 72 6d 53 43 58 20 | 3d 20 54 48 49 53 2e 63 |FormSCX |= THIS.c|
|000049a0| 46 6f 72 6d 53 43 58 0d | 0a 0d 0a 09 09 49 46 20 |FormSCX.|.....IF |
|000049b0| 6d 2e 73 79 73 63 68 20 | 23 20 2d 31 20 41 4e 44 |m.sysch |# -1 AND|
|000049c0| 20 54 59 50 45 28 22 78 | 6c 61 70 70 22 29 20 3d | TYPE("x|lapp") =|
|000049d0| 20 22 4f 22 20 41 4e 44 | 20 78 6c 61 70 70 2e 77 | "O" AND| xlapp.w|
|000049e0| 6f 72 6b 62 6f 6f 6b 73 | 2e 63 6f 75 6e 74 20 3d |orkbooks|.count =|
|000049f0| 20 30 0d 0a 09 09 09 78 | 6c 61 70 70 2e 77 6f 72 | 0.....x|lapp.wor|
|00004a00| 6b 62 6f 6f 6b 73 2e 61 | 64 64 0d 0a 09 09 45 4e |kbooks.a|dd....EN|
|00004a10| 44 49 46 0d 0a 09 09 44 | 4f 20 46 4f 52 4d 20 22 |DIF....D|O FORM "|
|00004a20| 26 63 46 6f 72 6d 53 43 | 58 22 20 4e 41 4d 45 20 |&cFormSC|X" NAME |
|00004a30| 78 6c 70 69 76 6f 74 66 | 6f 72 6d 20 4c 49 4e 4b |xlpivotf|orm LINK|
|00004a40| 45 44 0d 0a 09 09 78 6c | 61 70 70 20 3d 20 78 6c |ED....xl|app = xl|
|00004a50| 70 69 76 6f 74 66 6f 72 | 6d 2e 6f 6c 65 63 6f 6e |pivotfor|m.olecon|
|00004a60| 74 72 6f 6c 31 2e 6f 62 | 6a 65 63 74 2e 61 70 70 |trol1.ob|ject.app|
|00004a70| 6c 69 63 61 74 69 6f 6e | 0d 0a 09 09 0d 0a 09 09 |lication|........|
|00004a80| 49 46 20 6d 2e 73 79 73 | 63 68 20 23 20 2d 31 09 |IF m.sys|ch # -1.|
|00004a90| 26 26 20 45 78 63 65 6c | 20 61 6c 72 65 61 64 79 |&& Excel| already|
|00004aa0| 20 72 75 6e 6e 69 6e 67 | 0d 0a 09 09 09 78 6c 61 | running|.....xla|
|00004ab0| 63 74 69 76 65 73 68 65 | 65 74 20 3d 20 78 6c 70 |ctiveshe|et = xlp|
|00004ac0| 69 76 6f 74 66 6f 72 6d | 2e 6f 6c 65 63 6f 6e 74 |ivotform|.olecont|
|00004ad0| 72 6f 6c 31 2e 6f 62 6a | 65 63 74 2e 70 61 72 65 |rol1.obj|ect.pare|
|00004ae0| 6e 74 2e 77 6f 72 6b 73 | 68 65 65 74 73 28 31 29 |nt.works|heets(1)|
|00004af0| 0d 0a 09 09 45 4c 53 45 | 0d 0a 09 09 09 78 6c 61 |....ELSE|.....xla|
|00004b00| 70 70 2e 77 69 6e 64 6f | 77 73 28 31 29 2e 61 63 |pp.windo|ws(1).ac|
|00004b10| 74 69 76 61 74 65 0d 0a | 09 09 09 78 6c 61 63 74 |tivate..|...xlact|
|00004b20| 69 76 65 73 68 65 65 74 | 20 3d 20 78 6c 61 70 70 |ivesheet| = xlapp|
|00004b30| 2e 61 63 74 69 76 65 73 | 68 65 65 74 0d 0a 09 09 |.actives|heet....|
|00004b40| 45 4e 44 49 46 0d 0a 45 | 4e 44 43 41 53 45 0d 0a |ENDIF..E|NDCASE..|
|00004b50| 0d 0a 49 46 20 54 48 49 | 53 2e 68 61 64 65 72 72 |..IF THI|S.haderr|
|00004b60| 6f 72 0d 0a 09 52 45 54 | 55 52 4e 0d 0a 45 4e 44 |or...RET|URN..END|
|00004b70| 49 46 0d 0a 0d 0a 54 48 | 49 53 2e 44 69 73 70 6c |IF....TH|IS.Displ|
|00004b80| 61 79 53 74 61 74 75 73 | 28 43 5f 57 41 49 54 4d |ayStatus|(C_WAITM|
|00004b90| 45 53 53 5f 4c 4f 43 29 | 0d 0a 0d 0a 2a 2d 20 47 |ESS_LOC)|....*- G|
|00004ba0| 65 74 20 64 61 74 61 20 | 2d 2d 20 73 68 6f 75 6c |et data |-- shoul|
|00004bb0| 64 20 75 73 65 20 73 61 | 6d 65 20 64 69 72 65 63 |d use sa|me direc|
|00004bc0| 74 6f 72 79 20 61 73 20 | 66 6f 78 70 72 6f 20 74 |tory as |foxpro t|
|00004bd0| 61 62 6c 65 0d 0a 53 45 | 4c 45 43 54 20 28 54 48 |able..SE|LECT (TH|
|00004be0| 49 53 2e 63 41 6c 69 61 | 73 29 0d 0a 6d 2e 63 44 |IS.cAlia|s)..m.cD|
|00004bf0| 42 51 50 61 74 68 20 3d | 20 46 55 4c 4c 28 53 45 |BQPath =| FULL(SE|
|00004c00| 54 28 22 44 45 46 41 55 | 4c 54 22 29 29 0d 0a 49 |T("DEFAU|LT"))..I|
|00004c10| 46 20 52 49 47 48 54 28 | 6d 2e 63 44 42 51 50 61 |F RIGHT(|m.cDBQPa|
|00004c20| 74 68 2c 31 29 20 3d 20 | 22 5c 22 20 0d 0a 09 6d |th,1) = |"\" ...m|
|00004c30| 2e 63 44 42 51 50 61 74 | 68 20 3d 20 4c 45 46 54 |.cDBQPat|h = LEFT|
|00004c40| 28 6d 2e 63 44 42 51 50 | 61 74 68 2c 4c 45 4e 28 |(m.cDBQP|ath,LEN(|
|00004c50| 6d 2e 63 44 42 51 50 61 | 74 68 29 2d 31 29 0d 0a |m.cDBQPa|th)-1)..|
|00004c60| 45 4e 44 49 46 0d 0a 0d | 0a 63 56 69 65 77 4e 61 |ENDIF...|.cViewNa|
|00004c70| 6d 65 20 3d 20 22 60 22 | 20 2b 20 4c 4f 57 45 52 |me = "`"| + LOWER|
|00004c80| 28 43 55 52 53 4f 52 47 | 45 54 50 52 4f 50 28 22 |(CURSORG|ETPROP("|
|00004c90| 73 6f 75 72 63 65 6e 61 | 6d 65 22 29 29 20 2b 20 |sourcena|me")) + |
|00004ca0| 22 60 22 0d 0a 6d 2e 63 | 46 69 65 6c 64 53 74 72 |"`"..m.c|FieldStr|
|00004cb0| 69 6e 67 20 3d 20 22 22 | 0d 0a 0d 0a 2a 20 47 65 |ing = ""|....* Ge|
|00004cc0| 74 20 74 68 65 20 66 69 | 65 6c 64 73 20 73 74 72 |t the fi|elds str|
|00004cd0| 69 6e 67 0d 0a 44 4f 20 | 43 41 53 45 0d 0a 09 43 |ing..DO |CASE...C|
|00004ce0| 41 53 45 20 43 55 52 53 | 4f 52 47 45 54 50 52 4f |ASE CURS|ORGETPRO|
|00004cf0| 50 28 27 73 6f 75 72 63 | 65 74 79 70 65 27 29 20 |P('sourc|etype') |
|00004d00| 23 20 33 20 20 26 26 76 | 69 65 77 73 0d 0a 09 09 |# 3 &&v|iews....|
|00004d10| 46 4f 52 20 69 20 3d 20 | 31 20 54 4f 20 41 4c 45 |FOR i = |1 TO ALE|
|00004d20| 4e 28 54 48 49 53 2e 61 | 41 75 74 6f 46 69 65 6c |N(THIS.a|AutoFiel|
|00004d30| 64 73 29 0d 0a 09 09 09 | 6d 2e 63 46 69 65 6c 64 |ds).....|m.cField|
|00004d40| 53 74 72 69 6e 67 20 3d | 20 6d 2e 63 46 69 65 6c |String =| m.cFiel|
|00004d50| 64 53 74 72 69 6e 67 20 | 2b 20 6d 2e 63 56 69 65 |dString |+ m.cVie|
|00004d60| 77 4e 61 6d 65 20 2b 22 | 2e 22 2b 20 4c 4f 57 45 |wName +"|."+ LOWE|
|00004d70| 52 28 54 48 49 53 2e 61 | 41 75 74 6f 46 69 65 6c |R(THIS.a|AutoFiel|
|00004d80| 64 73 5b 6d 2e 69 5d 29 | 0d 0a 09 09 09 49 46 20 |ds[m.i])|.....IF |
|00004d90| 6d 2e 69 20 3d 20 41 4c | 45 4e 28 54 48 49 53 2e |m.i = AL|EN(THIS.|
|00004da0| 61 41 75 74 6f 46 69 65 | 6c 64 73 29 0d 0a 09 09 |aAutoFie|lds)....|
|00004db0| 09 09 45 58 49 54 0d 0a | 09 09 09 45 4e 44 49 46 |..EXIT..|...ENDIF|
|00004dc0| 0d 0a 09 09 09 6d 2e 63 | 46 69 65 6c 64 53 74 72 |.....m.c|FieldStr|
|00004dd0| 69 6e 67 20 3d 20 6d 2e | 63 46 69 65 6c 64 53 74 |ing = m.|cFieldSt|
|00004de0| 72 69 6e 67 20 2b 20 22 | 2c 20 22 0d 0a 09 09 45 |ring + "|, "....E|
|00004df0| 4e 44 46 4f 52 0d 0a 09 | 09 6d 2e 63 46 69 65 6c |NDFOR...|.m.cFiel|
|00004e00| 64 53 74 72 69 6e 67 20 | 3d 20 22 53 45 4c 45 43 |dString |= "SELEC|
|00004e10| 54 20 22 20 2b 20 6d 2e | 63 46 69 65 6c 64 53 74 |T " + m.|cFieldSt|
|00004e20| 72 69 6e 67 20 2b 20 22 | 20 46 52 4f 4d 20 22 0d |ring + "| FROM ".|
|00004e30| 0a 09 09 49 46 20 4c 45 | 4e 28 6d 2e 63 46 69 65 |...IF LE|N(m.cFie|
|00004e40| 6c 64 53 74 72 69 6e 67 | 29 20 3e 20 32 33 30 0d |ldString|) > 230.|
|00004e50| 0a 09 09 09 6d 2e 63 46 | 69 65 6c 64 53 74 72 69 |....m.cF|ieldStri|
|00004e60| 6e 67 20 3d 20 22 53 45 | 4c 45 43 54 20 2a 20 46 |ng = "SE|LECT * F|
|00004e70| 52 4f 4d 20 22 0d 0a 09 | 09 45 4e 44 49 46 0d 0a |ROM "...|.ENDIF..|
|00004e80| 09 43 41 53 45 20 2e 46 | 2e 20 26 26 20 41 4c 45 |.CASE .F|. && ALE|
|00004e90| 4e 28 54 48 49 53 2e 61 | 41 75 74 6f 46 69 65 6c |N(THIS.a|AutoFiel|
|00004ea0| 64 73 29 20 3d 20 46 43 | 4f 55 4e 54 28 29 20 4f |ds) = FC|OUNT() O|
|00004eb0| 52 20 45 4d 50 54 59 28 | 54 48 49 53 2e 61 41 75 |R EMPTY(|THIS.aAu|
|00004ec0| 74 6f 46 69 65 6c 64 73 | 5b 31 5d 29 0d 0a 09 09 |toFields|[1])....|
|00004ed0| 6d 2e 63 46 69 65 6c 64 | 53 74 72 69 6e 67 20 3d |m.cField|String =|
|00004ee0| 20 22 53 45 4c 45 43 54 | 20 2a 20 46 52 4f 4d 20 | "SELECT| * FROM |
|00004ef0| 22 0d 0a 09 4f 54 48 45 | 52 57 49 53 45 0d 0a 09 |"...OTHE|RWISE...|
|00004f00| 09 46 4f 52 20 69 20 3d | 20 31 20 54 4f 20 41 4c |.FOR i =| 1 TO AL|
|00004f10| 45 4e 28 54 48 49 53 2e | 61 41 75 74 6f 46 69 65 |EN(THIS.|aAutoFie|
|00004f20| 6c 64 73 29 0d 0a 09 09 | 09 6d 2e 63 46 69 65 6c |lds)....|.m.cFiel|
|00004f30| 64 53 74 72 69 6e 67 20 | 3d 20 6d 2e 63 46 69 65 |dString |= m.cFie|
|00004f40| 6c 64 53 74 72 69 6e 67 | 20 2b 20 54 48 49 53 2e |ldString| + THIS.|
|00004f50| 61 41 75 74 6f 46 69 65 | 6c 64 73 5b 6d 2e 69 5d |aAutoFie|lds[m.i]|
|00004f60| 0d 0a 09 09 09 49 46 20 | 6d 2e 69 20 3d 20 41 4c |.....IF |m.i = AL|
|00004f70| 45 4e 28 54 48 49 53 2e | 61 41 75 74 6f 46 69 65 |EN(THIS.|aAutoFie|
|00004f80| 6c 64 73 29 0d 0a 09 09 | 09 09 45 58 49 54 0d 0a |lds)....|..EXIT..|
|00004f90| 09 09 09 45 4e 44 49 46 | 0d 0a 09 09 09 6d 2e 63 |...ENDIF|.....m.c|
|00004fa0| 46 69 65 6c 64 53 74 72 | 69 6e 67 20 3d 20 6d 2e |FieldStr|ing = m.|
|00004fb0| 63 46 69 65 6c 64 53 74 | 72 69 6e 67 20 2b 20 22 |cFieldSt|ring + "|
|00004fc0| 2c 22 0d 0a 09 09 45 4e | 44 46 4f 52 0d 0a 09 09 |,"....EN|DFOR....|
|00004fd0| 6d 2e 63 46 69 65 6c 64 | 53 74 72 69 6e 67 20 3d |m.cField|String =|
|00004fe0| 20 22 53 45 4c 45 43 54 | 20 22 20 2b 20 6d 2e 63 | "SELECT| " + m.c|
|00004ff0| 46 69 65 6c 64 53 74 72 | 69 6e 67 20 2b 20 22 20 |FieldStr|ing + " |
|00005000| 46 52 4f 4d 20 22 0d 0a | 09 09 49 46 20 4c 45 4e |FROM "..|..IF LEN|
|00005010| 28 6d 2e 63 46 69 65 6c | 64 53 74 72 69 6e 67 29 |(m.cFiel|dString)|
|00005020| 20 3e 20 32 33 30 0d 0a | 09 09 09 6d 2e 63 46 69 | > 230..|...m.cFi|
|00005030| 65 6c 64 53 74 72 69 6e | 67 20 3d 20 22 53 45 4c |eldStrin|g = "SEL|
|00005040| 45 43 54 20 2a 20 46 52 | 4f 4d 20 22 0d 0a 09 09 |ECT * FR|OM "....|
|00005050| 45 4e 44 49 46 0d 0a 45 | 4e 44 43 41 53 45 0d 0a |ENDIF..E|NDCASE..|
|00005060| 0d 0a 2a 2a 20 43 6f 64 | 65 20 66 6f 72 20 63 72 |..** Cod|e for cr|
|00005070| 65 61 74 69 6e 67 20 50 | 69 76 6f 74 54 61 62 6c |eating P|ivotTabl|
|00005080| 65 20 61 6e 20 0d 0a 2a | 2a 20 65 78 74 65 72 6e |e an ..*|* extern|
|00005090| 61 6c 20 64 61 74 61 73 | 6f 75 72 63 65 20 64 69 |al datas|ource di|
|000050a0| 72 65 63 74 6c 79 0d 0a | 0d 0a 44 49 4d 45 4e 53 |rectly..|..DIMENS|
|000050b0| 49 4f 4e 20 61 4f 44 42 | 43 53 6f 75 72 63 65 5b |ION aODB|CSource[|
|000050c0| 32 5d 0d 0a 2a 20 20 44 | 53 4e 20 3d 20 44 61 74 |2]..* D|SN = Dat|
|000050d0| 61 20 53 6f 75 72 63 65 | 20 4e 61 6d 65 2c 20 46 |a Source| Name, F|
|000050e0| 49 4c 20 3d 20 46 69 6c | 65 20 54 79 70 65 2c 44 |IL = Fil|e Type,D|
|000050f0| 42 51 20 3d 20 44 61 74 | 61 20 44 69 72 65 63 74 |BQ = Dat|a Direct|
|00005100| 6f 72 79 0d 0a 2a 20 22 | 53 6f 75 72 63 65 54 79 |ory..* "|SourceTy|
|00005110| 70 65 3d 44 42 43 3b 45 | 78 63 6c 75 73 69 76 65 |pe=DBC;E|xclusive|
|00005120| 3d 4e 6f 3b 42 61 63 6b | 67 72 6f 75 6e 64 46 65 |=No;Back|groundFe|
|00005130| 74 63 68 3d 4e 6f 3b 43 | 6f 6c 6c 61 74 65 3d 4d |tch=No;C|ollate=M|
|00005140| 61 63 68 69 6e 65 3b 22 | 0d 0a 2a 20 22 44 53 4e |achine;"|..* "DSN|
|00005150| 3d 56 69 73 75 61 6c 20 | 46 6f 78 50 72 6f 20 54 |=Visual |FoxPro T|
|00005160| 61 62 6c 65 73 3b 53 6f | 75 72 63 65 44 42 3d 63 |ables;So|urceDB=c|
|00005170| 3a 5c 76 66 70 3b 53 6f | 75 72 63 65 54 79 70 65 |:\vfp;So|urceType|
|00005180| 3d 44 42 46 3b 45 78 63 | 6c 75 73 69 76 65 3d 4e |=DBF;Exc|lusive=N|
|00005190| 6f 3b 42 61 63 6b 67 72 | 6f 75 6e 64 46 65 74 63 |o;Backgr|oundFetc|
|000051a0| 68 3d 4e 6f 3b 43 6f 6c | 6c 61 74 65 3d 47 45 4e |h=No;Col|late=GEN|
|000051b0| 45 52 41 4c 3b 22 0d 0a | 0d 0a 61 4f 44 42 43 53 |ERAL;"..|..aODBCS|
|000051c0| 6f 75 72 63 65 5b 31 5d | 20 3d 20 22 44 53 4e 3d |ource[1]| = "DSN=|
|000051d0| 22 20 2b 20 54 48 49 53 | 2e 63 4f 44 42 43 5f 44 |" + THIS|.cODBC_D|
|000051e0| 53 4e 20 2b 20 3b 0d 0a | 09 20 22 3b 53 6f 75 72 |SN + ;..|. ";Sour|
|000051f0| 63 65 44 42 3d 22 2b 49 | 49 46 28 45 4d 50 54 59 |ceDB="+I|IF(EMPTY|
|00005200| 28 54 48 49 53 2e 63 44 | 42 43 4e 61 6d 65 29 2c |(THIS.cD|BCName),|
|00005210| 6d 2e 63 44 42 51 50 61 | 74 68 2c 54 48 49 53 2e |m.cDBQPa|th,THIS.|
|00005220| 63 44 42 43 4e 61 6d 65 | 29 2b 3b 0d 0a 09 20 22 |cDBCName|)+;... "|
|00005230| 3b 53 6f 75 72 63 65 54 | 79 70 65 3d 22 2b 49 49 |;SourceT|ype="+II|
|00005240| 46 28 45 4d 50 54 59 28 | 54 48 49 53 2e 63 44 42 |F(EMPTY(|THIS.cDB|
|00005250| 43 4e 61 6d 65 29 2c 22 | 44 42 46 22 2c 22 44 42 |CName),"|DBF","DB|
|00005260| 43 22 29 2b 3b 0d 0a 09 | 20 22 3b 45 78 63 6c 75 |C")+;...| ";Exclu|
|00005270| 73 69 76 65 3d 4e 6f 22 | 2b 3b 0d 0a 09 20 22 3b |sive=No"|+;... ";|
|00005280| 42 61 63 6b 67 72 6f 75 | 6e 64 46 65 74 63 68 3d |Backgrou|ndFetch=|
|00005290| 59 65 73 3b 22 0d 0a 0d | 0a 44 4f 20 43 41 53 45 |Yes;"...|.DO CASE|
|000052a0| 0d 0a 09 43 41 53 45 20 | 43 55 52 53 4f 52 47 45 |...CASE |CURSORGE|
|000052b0| 54 50 52 4f 50 28 22 73 | 6f 75 72 63 65 74 79 70 |TPROP("s|ourcetyp|
|000052c0| 65 22 29 3d 33 0d 0a 09 | 09 61 4f 44 42 43 53 6f |e")=3...|.aODBCSo|
|000052d0| 75 72 63 65 5b 32 5d 20 | 3d 20 6d 2e 63 46 69 65 |urce[2] |= m.cFie|
|000052e0| 6c 64 53 74 72 69 6e 67 | 20 2b 20 22 60 22 20 2b |ldString| + "`" +|
|000052f0| 20 44 42 46 28 29 20 2b | 20 22 60 22 20 2b 20 22 | DBF() +| "`" + "|
|00005300| 20 22 20 2b 20 41 4c 49 | 41 53 28 29 0d 0a 09 4f | " + ALI|AS()...O|
|00005310| 54 48 45 52 57 49 53 45 | 0d 0a 09 09 61 4f 44 42 |THERWISE|....aODB|
|00005320| 43 53 6f 75 72 63 65 5b | 32 5d 20 3d 20 6d 2e 63 |CSource[|2] = m.c|
|00005330| 46 69 65 6c 64 53 74 72 | 69 6e 67 20 2b 20 6d 2e |FieldStr|ing + m.|
|00005340| 63 56 69 65 77 4e 61 6d | 65 20 2b 20 22 20 22 20 |cViewNam|e + " " |
|00005350| 2b 20 6d 2e 63 56 69 65 | 77 4e 61 6d 65 09 09 09 |+ m.cVie|wName...|
|00005360| 0d 0a 45 4e 44 43 41 53 | 45 0d 0a 0d 0a 78 6c 61 |..ENDCAS|E....xla|
|00005370| 63 74 69 76 65 73 68 65 | 65 74 2e 70 69 76 6f 74 |ctiveshe|et.pivot|
|00005380| 54 61 62 6c 65 57 69 7a | 61 72 64 28 32 2c 40 61 |TableWiz|ard(2,@a|
|00005390| 4f 44 42 43 53 6f 75 72 | 63 65 29 0d 0a 0d 0a 2a |ODBCSour|ce)....*|
|000053a0| 20 43 68 65 63 6b 20 66 | 6f 72 20 70 72 6f 62 6c | Check f|or probl|
|000053b0| 65 6d 20 77 69 74 68 20 | 61 63 74 69 76 65 63 65 |em with |activece|
|000053c0| 6c 6c 20 6e 6f 74 20 70 | 61 72 74 20 6f 66 20 50 |ll not p|art of P|
|000053d0| 69 76 6f 74 54 61 62 6c | 65 0d 0a 49 46 20 54 48 |ivotTabl|e..IF TH|
|000053e0| 49 53 2e 68 61 64 65 72 | 72 6f 72 20 4f 52 20 28 |IS.hader|ror OR (|
|000053f0| 54 59 50 45 28 22 78 6c | 61 70 70 2e 61 63 74 69 |TYPE("xl|app.acti|
|00005400| 76 65 63 65 6c 6c 2e 70 | 69 76 6f 74 74 61 62 6c |vecell.p|ivottabl|
|00005410| 65 22 29 23 20 22 4f 22 | 20 41 4e 44 3b 0d 0a 09 |e")# "O"| AND;...|
|00005420| 54 59 50 45 28 22 78 6c | 61 63 74 69 76 65 73 68 |TYPE("xl|activesh|
|00005430| 65 65 74 2e 63 65 6c 6c | 73 28 31 2c 31 29 2e 70 |eet.cell|s(1,1).p|
|00005440| 69 76 6f 74 74 61 62 6c | 65 22 29 23 22 4f 22 29 |ivottabl|e")#"O")|
|00005450| 0d 0a 09 4d 45 53 53 41 | 47 45 42 4f 58 28 45 5f |...MESSA|GEBOX(E_|
|00005460| 4e 4f 50 49 56 54 41 42 | 4c 45 5f 4c 4f 43 29 0d |NOPIVTAB|LE_LOC).|
|00005470| 0a 09 52 45 54 55 52 4e | 0d 0a 45 4e 44 49 46 0d |..RETURN|..ENDIF.|
|00005480| 0a 0d 0a 63 50 69 76 6f | 74 4e 61 6d 65 20 3d 20 |...cPivo|tName = |
|00005490| 78 6c 61 63 74 69 76 65 | 73 68 65 65 74 2e 70 69 |xlactive|sheet.pi|
|000054a0| 76 6f 74 54 61 62 6c 65 | 73 28 31 29 2e 6e 61 6d |votTable|s(1).nam|
|000054b0| 65 0d 0a 0d 0a 2a 2d 20 | 53 65 74 20 70 69 76 6f |e....*- |Set pivo|
|000054c0| 74 20 66 69 65 6c 64 73 | 0d 0a 2a 2d 20 41 64 64 |t fields|..*- Add|
|000054d0| 20 72 6f 77 20 66 69 65 | 6c 64 0d 0a 49 46 20 21 | row fie|ld..IF !|
|000054e0| 45 4d 50 54 59 28 54 48 | 49 53 2e 63 50 69 76 46 |EMPTY(TH|IS.cPivF|
|000054f0| 6c 64 52 6f 77 29 0d 0a | 09 78 6c 61 63 74 69 76 |ldRow)..|.xlactiv|
|00005500| 65 73 68 65 65 74 2e 70 | 69 76 6f 74 54 61 62 6c |esheet.p|ivotTabl|
|00005510| 65 73 28 6d 2e 63 50 69 | 76 6f 74 4e 61 6d 65 29 |es(m.cPi|votName)|
|00005520| 2e 41 64 64 46 69 65 6c | 64 73 28 54 48 49 53 2e |.AddFiel|ds(THIS.|
|00005530| 63 50 69 76 46 6c 64 52 | 6f 77 29 0d 0a 45 4e 44 |cPivFldR|ow)..END|
|00005540| 49 46 0d 0a 0d 0a 2a 2d | 20 41 64 64 20 63 6f 6c |IF....*-| Add col|
|00005550| 75 6d 6e 20 66 69 65 6c | 64 0d 0a 49 46 20 21 45 |umn fiel|d..IF !E|
|00005560| 4d 50 54 59 28 54 48 49 | 53 2e 63 50 69 76 46 6c |MPTY(THI|S.cPivFl|
|00005570| 64 43 6f 6c 29 0d 0a 09 | 78 6c 61 63 74 69 76 65 |dCol)...|xlactive|
|00005580| 73 68 65 65 74 2e 70 69 | 76 6f 74 54 61 62 6c 65 |sheet.pi|votTable|
|00005590| 73 28 6d 2e 63 50 69 76 | 6f 74 4e 61 6d 65 29 2e |s(m.cPiv|otName).|
|000055a0| 50 69 76 6f 74 46 69 65 | 6c 64 73 28 54 48 49 53 |PivotFie|lds(THIS|
|000055b0| 2e 63 50 69 76 46 6c 64 | 43 6f 6c 29 2e 6f 72 69 |.cPivFld|Col).ori|
|000055c0| 65 6e 74 61 74 69 6f 6e | 20 3d 20 32 0d 0a 45 4e |entation| = 2..EN|
|000055d0| 44 49 46 0d 0a 0d 0a 2a | 2d 20 41 64 64 20 70 61 |DIF....*|- Add pa|
|000055e0| 67 65 20 66 69 65 6c 64 | 0d 0a 49 46 20 21 45 4d |ge field|..IF !EM|
|000055f0| 50 54 59 28 54 48 49 53 | 2e 63 50 69 76 46 6c 64 |PTY(THIS|.cPivFld|
|00005600| 50 61 67 65 29 0d 0a 09 | 78 6c 61 63 74 69 76 65 |Page)...|xlactive|
|00005610| 73 68 65 65 74 2e 70 69 | 76 6f 74 54 61 62 6c 65 |sheet.pi|votTable|
|00005620| 73 28 6d 2e 63 50 69 76 | 6f 74 4e 61 6d 65 29 2e |s(m.cPiv|otName).|
|00005630| 50 69 76 6f 74 46 69 65 | 6c 64 73 28 54 48 49 53 |PivotFie|lds(THIS|
|00005640| 2e 63 50 69 76 46 6c 64 | 50 61 67 65 29 2e 6f 72 |.cPivFld|Page).or|
|00005650| 69 65 6e 74 61 74 69 6f | 6e 20 3d 20 33 0d 0a 45 |ientatio|n = 3..E|
|00005660| 4e 44 49 46 0d 0a 0d 0a | 2a 2d 20 41 64 64 20 64 |NDIF....|*- Add d|
|00005670| 61 74 61 20 66 69 65 6c | 64 0d 0a 49 46 20 21 45 |ata fiel|d..IF !E|
|00005680| 4d 50 54 59 28 54 48 49 | 53 2e 63 50 69 76 46 6c |MPTY(THI|S.cPivFl|
|00005690| 64 44 61 74 61 29 0d 0a | 09 78 6c 61 63 74 69 76 |dData)..|.xlactiv|
|000056a0| 65 73 68 65 65 74 2e 70 | 69 76 6f 74 54 61 62 6c |esheet.p|ivotTabl|
|000056b0| 65 73 28 6d 2e 63 50 69 | 76 6f 74 4e 61 6d 65 29 |es(m.cPi|votName)|
|000056c0| 2e 50 69 76 6f 74 46 69 | 65 6c 64 73 28 54 48 49 |.PivotFi|elds(THI|
|000056d0| 53 2e 63 50 69 76 46 6c | 64 44 61 74 61 29 2e 6f |S.cPivFl|dData).o|
|000056e0| 72 69 65 6e 74 61 74 69 | 6f 6e 20 3d 20 34 0d 0a |rientati|on = 4..|
|000056f0| 09 78 6c 44 61 74 61 66 | 6c 64 20 3d 20 78 6c 61 |.xlDataf|ld = xla|
|00005700| 63 74 69 76 65 73 68 65 | 65 74 2e 70 69 76 6f 74 |ctiveshe|et.pivot|
|00005710| 54 61 62 6c 65 73 28 6d | 2e 63 50 69 76 6f 74 4e |Tables(m|.cPivotN|
|00005720| 61 6d 65 29 2e 64 61 74 | 61 66 69 65 6c 64 73 28 |ame).dat|afields(|
|00005730| 29 0d 0a 09 49 46 20 78 | 6c 44 61 74 61 66 6c 64 |)...IF x|lDatafld|
|00005740| 2e 69 74 65 6d 28 31 29 | 2e 66 75 6e 63 74 69 6f |.item(1)|.functio|
|00005750| 6e 20 3d 20 58 4c 43 4f | 55 4e 54 0d 0a 09 09 2a |n = XLCO|UNT....*|
|00005760| 2d 20 54 65 73 74 20 69 | 66 20 69 74 65 6d 20 69 |- Test i|f item i|
|00005770| 73 20 6e 75 6d 65 72 69 | 63 0d 0a 09 09 46 4f 52 |s numeri|c....FOR|
|00005780| 20 69 20 3d 20 31 20 54 | 4f 20 41 4c 45 4e 28 54 | i = 1 T|O ALEN(T|
|00005790| 48 49 53 2e 61 46 6c 64 | 4c 69 73 74 2c 31 29 0d |HIS.aFld|List,1).|
|000057a0| 0a 09 09 09 49 46 20 54 | 48 49 53 2e 61 46 6c 64 |....IF T|HIS.aFld|
|000057b0| 4c 69 73 74 5b 6d 2e 69 | 2c 31 5d 20 3d 3d 20 55 |List[m.i|,1] == U|
|000057c0| 50 50 45 52 28 54 48 49 | 53 2e 63 50 69 76 46 6c |PPER(THI|S.cPivFl|
|000057d0| 64 44 61 74 61 29 0d 0a | 09 09 09 09 49 46 20 41 |dData)..|....IF A|
|000057e0| 54 28 54 48 49 53 2e 61 | 46 6c 64 4c 69 73 74 5b |T(THIS.a|FldList[|
|000057f0| 6d 2e 69 2c 32 5d 2c 22 | 4e 46 59 42 22 29 20 23 |m.i,2],"|NFYB") #|
|00005800| 20 30 0d 0a 09 09 09 09 | 09 54 48 49 53 2e 6c 49 | 0......|.THIS.lI|
|00005810| 73 4e 75 6d 65 72 69 63 | 20 3d 20 2e 54 2e 0d 0a |sNumeric| = .T...|
|00005820| 09 09 09 09 45 4e 44 49 | 46 0d 0a 09 09 09 09 45 |....ENDI|F......E|
|00005830| 58 49 54 0d 0a 09 09 09 | 45 4e 44 49 46 0d 0a 09 |XIT.....|ENDIF...|
|00005840| 09 45 4e 44 46 4f 52 0d | 0a 09 09 49 46 20 54 48 |.ENDFOR.|...IF TH|
|00005850| 49 53 2e 6c 49 73 4e 75 | 6d 65 72 69 63 0d 0a 09 |IS.lIsNu|meric...|
|00005860| 09 09 78 6c 61 63 74 69 | 76 65 73 68 65 65 74 2e |..xlacti|vesheet.|
|00005870| 70 69 76 6f 74 54 61 62 | 6c 65 73 28 6d 2e 63 50 |pivotTab|les(m.cP|
|00005880| 69 76 6f 74 4e 61 6d 65 | 29 2e 50 69 76 6f 74 46 |ivotName|).PivotF|
|00005890| 69 65 6c 64 73 28 78 6c | 44 61 74 61 66 6c 64 2e |ields(xl|Datafld.|
|000058a0| 69 74 65 6d 28 31 29 2e | 76 61 6c 75 65 29 2e 66 |item(1).|value).f|
|000058b0| 75 6e 63 74 69 6f 6e 20 | 3d 20 30 0d 0a 09 09 45 |unction |= 0....E|
|000058c0| 4e 44 49 46 0d 0a 09 45 | 4e 44 49 46 0d 0a 0d 0a |NDIF...E|NDIF....|
|000058d0| 09 49 46 20 21 54 48 49 | 53 2e 6c 48 61 73 43 6f |.IF !THI|S.lHasCo|
|000058e0| 6c 75 6d 6e 54 6f 74 61 | 6c 73 09 09 26 26 20 43 |lumnTota|ls..&& C|
|000058f0| 6f 6c 75 6d 6e 20 74 6f | 74 61 6c 73 0d 0a 09 09 |olumn to|tals....|
|00005900| 78 6c 61 63 74 69 76 65 | 73 68 65 65 74 2e 70 69 |xlactive|sheet.pi|
|00005910| 76 6f 74 54 61 62 6c 65 | 73 28 6d 2e 63 50 69 76 |votTable|s(m.cPiv|
|00005920| 6f 74 4e 61 6d 65 29 2e | 43 6f 6c 75 6d 6e 47 72 |otName).|ColumnGr|
|00005930| 61 6e 64 20 3d 20 2e 46 | 2e 0d 0a 09 45 4e 44 49 |and = .F|....ENDI|
|00005940| 46 0d 0a 0d 0a 09 49 46 | 20 21 54 48 49 53 2e 6c |F.....IF| !THIS.l|
|00005950| 48 61 73 52 6f 77 54 6f | 74 61 6c 73 09 09 09 26 |HasRowTo|tals...&|
|00005960| 26 20 52 6f 77 20 74 6f | 74 61 6c 73 0d 0a 09 09 |& Row to|tals....|
|00005970| 78 6c 61 63 74 69 76 65 | 73 68 65 65 74 2e 70 69 |xlactive|sheet.pi|
|00005980| 76 6f 74 54 61 62 6c 65 | 73 28 6d 2e 63 50 69 76 |votTable|s(m.cPiv|
|00005990| 6f 74 4e 61 6d 65 29 2e | 52 6f 77 47 72 61 6e 64 |otName).|RowGrand|
|000059a0| 20 3d 20 2e 46 2e 0d 0a | 09 45 4e 44 49 46 0d 0a | = .F...|.ENDIF..|
|000059b0| 45 4e 44 49 46 0d 0a 0d | 0a 54 48 49 53 2e 44 69 |ENDIF...|.THIS.Di|
|000059c0| 73 70 6c 61 79 53 74 61 | 74 75 73 28 29 0d 0a 0d |splaySta|tus()...|
|000059d0| 0a 2a 20 48 61 6e 64 6c | 65 20 4f 75 74 70 75 74 |.* Handl|e Output|
|000059e0| 20 61 63 74 69 6f 6e 20 | 68 65 72 65 0d 0a 44 4f | action |here..DO|
|000059f0| 20 43 41 53 45 0d 0a 09 | 43 41 53 45 20 54 48 49 | CASE...|CASE THI|
|00005a00| 53 2e 6e 41 63 74 69 6f | 6e 20 3d 20 31 09 26 26 |S.nActio|n = 1.&&|
|00005a10| 45 78 63 65 6c 20 50 69 | 76 6f 74 54 61 62 6c 65 |Excel Pi|votTable|
|00005a20| 0d 0a 09 43 41 53 45 20 | 54 48 49 53 2e 6e 41 63 |...CASE |THIS.nAc|
|00005a30| 74 69 6f 6e 20 3d 20 32 | 09 26 26 46 6f 78 50 72 |tion = 2|.&&FoxPr|
|00005a40| 6f 20 66 6f 72 6d 20 77 | 69 74 68 20 50 69 76 6f |o form w|ith Pivo|
|00005a50| 74 54 61 62 6c 65 0d 0a | 09 09 78 6c 70 69 76 6f |tTable..|..xlpivo|
|00005a60| 74 66 6f 72 6d 2e 73 61 | 76 65 61 73 28 54 48 49 |tform.sa|veas(THI|
|00005a70| 53 2e 63 4f 75 74 46 69 | 6c 65 29 0d 0a 09 09 6d |S.cOutFi|le)....m|
|00005a80| 2e 63 4e 65 77 46 69 6c | 65 20 3d 20 22 27 22 2b |.cNewFil|e = "'"+|
|00005a90| 54 48 49 53 2e 63 4f 75 | 74 46 69 6c 65 2b 22 27 |THIS.cOu|tFile+"'|
|00005aa0| 22 0d 0a 09 09 49 46 20 | 21 54 48 49 53 2e 6c 48 |"....IF |!THIS.lH|
|00005ab0| 61 73 4e 6f 54 61 73 6b | 0d 0a 09 09 09 5f 53 48 |asNoTask|....._SH|
|00005ac0| 45 4c 4c 20 3d 20 5b 4d | 4f 44 49 46 59 20 46 4f |ELL = [M|ODIFY FO|
|00005ad0| 52 4d 20 26 63 4e 65 77 | 46 69 6c 65 20 4e 4f 57 |RM &cNew|File NOW|
|00005ae0| 41 49 54 5d 0d 0a 09 09 | 45 4e 44 49 46 0d 0a 09 |AIT]....|ENDIF...|
|00005af0| 09 2a 20 53 65 65 20 69 | 66 20 65 78 63 65 6c 20 |.* See i|f excel |
|00005b00| 77 61 73 20 61 6c 72 65 | 61 64 79 20 76 69 73 69 |was alre|ady visi|
|00005b10| 62 6c 65 0d 0a 09 09 52 | 45 4c 45 41 53 45 20 78 |ble....R|ELEASE x|
|00005b20| 6c 61 63 74 69 76 65 73 | 68 65 65 74 0d 0a 09 09 |lactives|heet....|
|00005b30| 49 46 20 6d 2e 73 79 73 | 63 68 20 3d 20 2d 31 0d |IF m.sys|ch = -1.|
|00005b40| 0a 09 09 09 78 6c 61 70 | 70 2e 71 75 69 74 0d 0a |....xlap|p.quit..|
|00005b50| 09 09 45 4e 44 49 46 0d | 0a 09 09 52 45 4c 45 41 |..ENDIF.|...RELEA|
|00005b60| 53 45 20 78 6c 61 70 70 | 2c 78 6c 70 69 76 6f 74 |SE xlapp|,xlpivot|
|00005b70| 66 6f 72 6d 0d 0a 45 4e | 44 43 41 53 45 0d 0a 0d |form..EN|DCASE...|
|00005b80| 0a 45 4e 44 50 52 4f 43 | 0d 0a 50 52 4f 43 45 44 |.ENDPROC|..PROCED|
|00005b90| 55 52 45 20 67 65 74 64 | 6f 73 6e 61 6d 65 0d 0a |URE getd|osname..|
|00005ba0| 4c 50 41 52 41 4d 45 54 | 45 52 20 63 44 6f 73 46 |LPARAMET|ER cDosF|
|00005bb0| 69 6c 65 4e 61 6d 65 2c | 6c 70 61 74 68 63 68 65 |ileName,|lpathche|
|00005bc0| 63 6b 0d 0a 0d 0a 4c 4f | 43 41 4c 20 67 6f 6f 64 |ck....LO|CAL good|
|00005bd0| 63 68 61 72 73 2c 62 61 | 64 63 68 61 72 73 2c 70 |chars,ba|dchars,p|
|00005be0| 61 74 68 63 68 61 72 73 | 2c 69 0d 0a 0d 0a 63 44 |athchars|,i....cD|
|00005bf0| 6f 73 46 69 6c 65 4e 61 | 6d 65 20 3d 20 53 54 52 |osFileNa|me = STR|
|00005c00| 54 52 41 4e 28 6d 2e 63 | 44 6f 73 46 69 6c 65 4e |TRAN(m.c|DosFileN|
|00005c10| 61 6d 65 2c 22 20 22 2c | 22 5f 22 29 0d 0a 0d 0a |ame," ",|"_")....|
|00005c20| 2a 20 4c 65 74 27 73 20 | 73 65 74 20 74 68 65 20 |* Let's |set the |
|00005c30| 74 72 75 65 20 62 61 64 | 20 63 68 61 72 61 63 74 |true bad| charact|
|00005c40| 65 72 73 20 77 68 69 63 | 68 20 61 72 65 6e 27 74 |ers whic|h aren't|
|00005c50| 20 61 6c 6c 6f 77 65 64 | 20 69 6e 20 66 69 65 6c | allowed| in fiel|
|00005c60| 64 73 0d 0a 2a 20 4e 6f | 74 65 3a 20 74 68 69 73 |ds..* No|te: this|
|00005c70| 20 77 69 6c 6c 20 64 69 | 66 66 65 72 20 62 61 73 | will di|ffer bas|
|00005c80| 65 64 20 6f 6e 20 63 6f | 64 65 20 70 61 67 65 0d |ed on co|de page.|
|00005c90| 0a 62 61 64 63 68 61 72 | 73 20 20 3d 20 27 81 82 |.badchar|s = '..|
|00005ca0| 83 84 85 86 87 88 89 8a | 8b 8c 8e 8f 90 91 92 93 |........|........|
|00005cb0| 94 95 96 97 98 99 9a a0 | a1 a2 a3 a4 a5 2f 2c 2d |........|...../,-|
|00005cc0| 3d 3b 7b 7d 5b 5d 21 40 | 23 24 25 5e 26 2a 3c 3e |=;{}[]!@|#$%^&*<>|
|00005cd0| 28 29 3f 27 2b 3b 0d 0a | 20 20 20 27 2b 7c 80 9b |()?'+;..| '+|..|
|00005ce0| 9c 9d 9e 9f a6 a7 a8 a9 | aa ab ac ad ae af b0 b1 |........|........|
|00005cf0| b2 b3 b4 b5 b6 b7 b8 b9 | ba bb bc bd be bf c0 c1 |........|........|
|00005d00| c2 c3 c4 c5 c6 c7 c8 c9 | ca cb cc cd ce cf 27 2b |........|......'+|
|00005d10| 3b 0d 0a 09 27 d0 d1 d2 | d3 d4 d5 d6 d7 d8 d9 da |;...'...|........|
|00005d20| db dc dd de df e0 e1 e2 | e3 e4 e5 e6 e7 e8 e9 ea |........|........|
|00005d30| eb ec ed ee ef f0 f1 f2 | f3 f4 f5 f6 f7 f8 f9 fa |........|........|
|00005d40| fb fc fd fe 27 2b 43 48 | 52 28 33 39 29 2b 22 20 |....'+CH|R(39)+" |
|00005d50| 22 0d 0a 09 0d 0a 67 6f | 6f 64 63 68 61 72 73 3d |".....go|odchars=|
|00005d60| 22 22 0d 0a 70 61 74 68 | 63 68 61 72 73 20 3d 20 |""..path|chars = |
|00005d70| 22 3a 5c 2e 22 0d 0a 0d | 0a 49 46 20 50 41 52 41 |":\."...|.IF PARA|
|00005d80| 4d 45 54 45 52 53 28 29 | 3d 31 20 4f 52 20 28 54 |METERS()|=1 OR (T|
|00005d90| 59 50 45 28 22 6d 2e 6c | 70 61 74 68 63 68 65 63 |YPE("m.l|pathchec|
|00005da0| 6b 22 29 3d 22 4c 22 20 | 41 4e 44 20 21 6d 2e 6c |k")="L" |AND !m.l|
|00005db0| 70 61 74 68 63 68 65 63 | 6b 29 0d 0a 09 62 61 64 |pathchec|k)...bad|
|00005dc0| 63 68 61 72 73 20 3d 20 | 6d 2e 62 61 64 63 68 61 |chars = |m.badcha|
|00005dd0| 72 73 20 2b 20 6d 2e 70 | 61 74 68 63 68 61 72 73 |rs + m.p|athchars|
|00005de0| 0d 0a 45 4e 44 49 46 0d | 0a 0d 0a 46 4f 52 20 69 |..ENDIF.|...FOR i|
|00005df0| 20 3d 20 31 20 54 4f 20 | 4c 45 4e 28 6d 2e 62 61 | = 1 TO |LEN(m.ba|
|00005e00| 64 63 68 61 72 73 29 0d | 0a 09 49 46 20 49 53 41 |dchars).|..IF ISA|
|00005e10| 4c 50 48 41 28 53 55 42 | 53 54 52 28 6d 2e 62 61 |LPHA(SUB|STR(m.ba|
|00005e20| 64 63 68 61 72 73 2c 6d | 2e 69 2c 31 29 29 0d 0a |dchars,m|.i,1))..|
|00005e30| 09 09 67 6f 6f 64 63 68 | 61 72 73 20 3d 20 6d 2e |..goodch|ars = m.|
|00005e40| 67 6f 6f 64 63 68 61 72 | 73 20 2b 20 53 55 42 53 |goodchar|s + SUBS|
|00005e50| 54 52 28 6d 2e 62 61 64 | 63 68 61 72 73 2c 6d 2e |TR(m.bad|chars,m.|
|00005e60| 69 2c 31 29 0d 0a 09 45 | 4e 44 49 46 0d 0a 45 4e |i,1)...E|NDIF..EN|
|00005e70| 44 46 4f 52 0d 0a 0d 0a | 62 61 64 63 68 61 72 73 |DFOR....|badchars|
|00005e80| 20 3d 20 43 48 52 54 52 | 41 4e 28 6d 2e 62 61 64 | = CHRTR|AN(m.bad|
|00005e90| 63 68 61 72 73 2c 6d 2e | 67 6f 6f 64 63 68 61 72 |chars,m.|goodchar|
|00005ea0| 73 2c 27 27 29 0d 0a 63 | 44 6f 73 46 69 6c 65 4e |s,'')..c|DosFileN|
|00005eb0| 61 6d 65 3d 20 53 55 42 | 53 54 52 28 43 48 52 54 |ame= SUB|STR(CHRT|
|00005ec0| 52 41 4e 28 6d 2e 63 44 | 6f 73 46 69 6c 65 4e 61 |RAN(m.cD|osFileNa|
|00005ed0| 6d 65 2c 6d 2e 62 61 64 | 63 68 61 72 73 2c 52 45 |me,m.bad|chars,RE|
|00005ee0| 50 4c 49 43 41 54 45 28 | 22 5f 22 2c 4c 45 4e 28 |PLICATE(|"_",LEN(|
|00005ef0| 6d 2e 62 61 64 63 68 61 | 72 73 29 2d 31 29 29 2c |m.badcha|rs)-1)),|
|00005f00| 31 2c 4c 45 4e 28 6d 2e | 63 44 6f 73 46 69 6c 65 |1,LEN(m.|cDosFile|
|00005f10| 4e 61 6d 65 29 29 0d 0a | 0d 0a 52 45 54 55 52 4e |Name))..|..RETURN|
|00005f20| 20 6d 2e 63 44 6f 73 46 | 69 6c 65 4e 61 6d 65 0d | m.cDosF|ileName.|
|00005f30| 0a 0d 0a 45 4e 44 50 52 | 4f 43 0d 0a 50 52 4f 43 |...ENDPR|OC..PROC|
|00005f40| 45 44 55 52 45 20 6d 73 | 71 75 65 72 79 63 68 65 |EDURE ms|queryche|
|00005f50| 63 6b 0d 0a 4c 4f 43 41 | 4c 20 6c 48 61 73 4d 53 |ck..LOCA|L lHasMS|
|00005f60| 51 75 65 72 79 2c 61 4d | 53 41 50 50 73 2c 6e 50 |Query,aM|SAPPs,nP|
|00005f70| 6f 73 2c 63 56 61 6c 75 | 65 2c 6f 52 65 67 2c 63 |os,cValu|e,oReg,c|
|00005f80| 50 61 74 68 56 61 6c 75 | 65 2c 63 48 6b 65 79 0d |PathValu|e,cHkey.|
|00005f90| 0a 0d 0a 2a 20 54 65 73 | 74 20 69 66 20 75 73 65 |...* Tes|t if use|
|00005fa0| 72 20 68 61 73 20 4d 53 | 20 51 75 65 72 79 20 63 |r has MS| Query c|
|00005fb0| 6f 72 72 65 63 74 6c 79 | 20 72 65 67 69 73 74 65 |orrectly| registe|
|00005fc0| 72 65 64 20 69 6e 20 52 | 65 67 69 73 74 72 79 20 |red in R|egistry |
|00005fd0| 28 69 2e 65 2e 20 76 32 | 2e 30 29 0d 0a 63 48 6b |(i.e. v2|.0)..cHk|
|00005fe0| 65 79 20 3d 20 49 49 46 | 28 54 48 49 53 2e 6e 43 |ey = IIF|(THIS.nC|
|00005ff0| 75 72 72 65 6e 74 4f 53 | 3d 4f 53 5f 57 33 32 53 |urrentOS|=OS_W32S|
|00006000| 2c 48 4b 45 59 5f 43 4c | 41 53 53 45 53 5f 52 4f |,HKEY_CL|ASSES_RO|
|00006010| 4f 54 2c 48 4b 45 59 5f | 4c 4f 43 41 4c 5f 4d 41 |OT,HKEY_|LOCAL_MA|
|00006020| 43 48 49 4e 45 29 0d 0a | 49 46 20 21 28 22 52 45 |CHINE)..|IF !("RE|
|00006030| 47 49 53 54 52 59 22 20 | 24 20 53 45 54 28 22 43 |GISTRY" |$ SET("C|
|00006040| 4c 41 53 53 22 29 29 0d | 0a 09 53 45 54 20 43 4c |LASS")).|..SET CL|
|00006050| 41 53 53 20 54 4f 20 72 | 65 67 69 73 74 72 79 20 |ASS TO r|egistry |
|00006060| 41 44 44 49 54 49 56 45 | 0d 0a 45 4e 44 49 46 0d |ADDITIVE|..ENDIF.|
|00006070| 0a 0d 0a 6f 52 65 67 20 | 3d 20 63 72 65 61 74 65 |...oReg |= create|
|00006080| 28 27 4f 6c 64 49 4e 49 | 52 65 67 27 29 0d 0a 63 |('OldINI|Reg')..c|
|00006090| 50 61 74 68 56 61 6c 75 | 65 20 3d 20 22 22 0d 0a |PathValu|e = ""..|
|000060a0| 0d 0a 49 46 20 6f 52 65 | 67 2e 47 65 74 52 65 67 |..IF oRe|g.GetReg|
|000060b0| 4b 65 79 28 43 5f 50 41 | 54 48 2c 40 63 50 61 74 |Key(C_PA|TH,@cPat|
|000060c0| 68 56 61 6c 75 65 2c 51 | 55 45 52 59 5f 52 4f 4f |hValue,Q|UERY_ROO|
|000060d0| 54 2c 6d 2e 63 48 6b 65 | 79 29 20 3d 20 45 52 52 |T,m.cHke|y) = ERR|
|000060e0| 4f 52 5f 53 55 43 43 45 | 53 53 20 41 4e 44 20 3b |OR_SUCCE|SS AND ;|
|000060f0| 0d 0a 09 46 49 4c 45 28 | 6d 2e 63 50 61 74 68 56 |...FILE(|m.cPathV|
|00006100| 61 6c 75 65 29 0d 0a 09 | 6c 48 61 73 4d 53 51 75 |alue)...|lHasMSQu|
|00006110| 65 72 79 20 3d 20 2e 54 | 2e 0d 0a 09 54 48 49 53 |ery = .T|....THIS|
|00006120| 2e 6c 48 61 73 4d 53 51 | 52 59 33 32 20 3d 20 41 |.lHasMSQ|RY32 = A|
|00006130| 54 43 28 43 5f 4d 53 51 | 52 59 33 32 2c 6d 2e 63 |TC(C_MSQ|RY32,m.c|
|00006140| 50 61 74 68 56 61 6c 75 | 65 29 23 30 0d 0a 45 4e |PathValu|e)#0..EN|
|00006150| 44 49 46 0d 0a 09 09 0d | 0a 44 4f 20 43 41 53 45 |DIF.....|.DO CASE|
|00006160| 0d 0a 09 43 41 53 45 20 | 6d 2e 6c 48 61 73 4d 53 |...CASE |m.lHasMS|
|00006170| 51 75 65 72 79 0d 0a 09 | 43 41 53 45 20 46 49 4c |Query...|CASE FIL|
|00006180| 45 28 47 45 54 45 4e 56 | 28 22 77 69 6e 64 69 72 |E(GETENV|("windir|
|00006190| 22 29 2b 22 5c 4d 53 41 | 50 50 53 5c 4d 53 51 55 |")+"\MSA|PPS\MSQU|
|000061a0| 45 52 59 5c 4d 53 51 55 | 45 52 59 2e 45 58 45 22 |ERY\MSQU|ERY.EXE"|
|000061b0| 29 0d 0a 09 09 6c 48 61 | 73 4d 53 51 75 65 72 79 |)....lHa|sMSQuery|
|000061c0| 20 3d 20 2e 54 2e 0d 0a | 09 4f 54 48 45 52 57 49 | = .T...|.OTHERWI|
|000061d0| 53 45 0d 0a 09 09 2a 20 | 43 68 65 63 6b 20 57 49 |SE....* |Check WI|
|000061e0| 4e 2e 49 4e 49 20 66 69 | 6c 65 0d 0a 09 09 44 49 |N.INI fi|le....DI|
|000061f0| 4d 45 4e 53 49 4f 4e 20 | 61 4d 53 41 50 50 73 5b |MENSION |aMSAPPs[|
|00006200| 31 5d 0d 0a 09 09 49 46 | 20 6f 72 65 67 2e 47 65 |1]....IF| oreg.Ge|
|00006210| 74 49 4e 49 53 65 63 74 | 69 6f 6e 28 40 61 4d 53 |tINISect|ion(@aMS|
|00006220| 41 50 50 73 2c 22 4d 53 | 41 50 50 53 22 29 20 3d |APPs,"MS|APPS") =|
|00006230| 20 45 52 52 4f 52 5f 53 | 55 43 43 45 53 53 0d 0a | ERROR_S|UCCESS..|
|00006240| 09 09 09 6e 50 6f 73 20 | 3d 20 41 53 43 41 4e 28 |...nPos |= ASCAN(|
|00006250| 61 4d 53 41 50 50 73 2c | 22 4d 53 51 55 45 52 59 |aMSAPPs,|"MSQUERY|
|00006260| 22 29 0d 0a 09 09 09 49 | 46 20 6d 2e 6e 50 6f 73 |").....I|F m.nPos|
|00006270| 20 23 20 30 0d 0a 09 09 | 09 09 63 56 61 6c 75 65 | # 0....|..cValue|
|00006280| 20 3d 20 22 22 0d 0a 09 | 09 09 09 49 46 20 6f 72 | = ""...|...IF or|
|00006290| 65 67 2e 47 65 74 49 4e | 49 45 6e 74 72 79 28 40 |eg.GetIN|IEntry(@|
|000062a0| 63 56 61 6c 75 65 2c 22 | 4d 53 41 50 50 53 22 2c |cValue,"|MSAPPS",|
|000062b0| 22 4d 53 51 55 45 52 59 | 22 29 20 3d 20 45 52 52 |"MSQUERY|") = ERR|
|000062c0| 4f 52 5f 53 55 43 43 45 | 53 53 0d 0a 09 09 09 09 |OR_SUCCE|SS......|
|000062d0| 09 49 46 20 46 49 4c 45 | 28 6d 2e 63 56 61 6c 75 |.IF FILE|(m.cValu|
|000062e0| 65 2b 22 5c 4d 53 51 55 | 45 52 59 2e 45 58 45 22 |e+"\MSQU|ERY.EXE"|
|000062f0| 29 0d 0a 09 09 09 09 09 | 09 6c 48 61 73 4d 53 51 |).......|.lHasMSQ|
|00006300| 75 65 72 79 20 3d 20 2e | 54 2e 0d 0a 09 09 09 09 |uery = .|T.......|
|00006310| 09 45 4e 44 49 46 0d 0a | 09 09 09 09 45 4e 44 49 |.ENDIF..|....ENDI|
|00006320| 46 0d 0a 09 09 09 45 4e | 44 49 46 0d 0a 09 09 45 |F.....EN|DIF....E|
|00006330| 4e 44 49 46 0d 0a 09 09 | 0d 0a 09 09 2a 20 43 68 |NDIF....|....* Ch|
|00006340| 65 63 6b 20 52 65 67 69 | 73 74 72 79 0d 0a 09 09 |eck Regi|stry....|
|00006350| 49 46 20 21 6c 48 61 73 | 4d 53 51 75 65 72 79 20 |IF !lHas|MSQuery |
|00006360| 41 4e 44 20 6f 52 65 67 | 2e 49 73 4b 65 79 28 22 |AND oReg|.IsKey("|
|00006370| 2e 71 72 79 22 29 0d 0a | 09 09 09 6c 48 61 73 4d |.qry")..|...lHasM|
|00006380| 53 51 75 65 72 79 20 3d | 20 2e 54 2e 09 09 09 09 |SQuery =| .T.....|
|00006390| 0d 0a 09 09 45 4e 44 49 | 46 0d 0a 09 09 0d 0a 45 |....ENDI|F......E|
|000063a0| 4e 44 43 41 53 45 0d 0a | 0d 0a 49 46 20 21 6d 2e |NDCASE..|..IF !m.|
|000063b0| 6c 48 61 73 4d 53 51 75 | 65 72 79 0d 0a 09 54 48 |lHasMSQu|ery...TH|
|000063c0| 49 53 2e 41 4c 45 52 54 | 28 45 5f 42 41 44 4d 53 |IS.ALERT|(E_BADMS|
|000063d0| 51 55 45 52 59 5f 4c 4f | 43 29 0d 0a 45 4e 44 49 |QUERY_LO|C)..ENDI|
|000063e0| 46 0d 0a 0d 0a 52 45 54 | 55 52 4e 20 6d 2e 6c 48 |F....RET|URN m.lH|
|000063f0| 61 73 4d 53 51 75 65 72 | 79 0d 0a 0d 0a 45 4e 44 |asMSQuer|y....END|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.
