squirrel/!Sqlimport/TemplatesB

Home » Archimedes archive » Zipped Apps » Squirrel » squirrel/!Sqlimport/TemplatesB

This website contains an archive of files for the Acorn Electron, BBC Micro, Acorn Archimedes, Commodore 16 and Commodore 64 computers, which Dominic Ford has rescued from his private collection of floppy disks and cassettes.

Some of these files were originally commercial releases in the 1980s and 1990s, but they are now widely available online. I assume that copyright over them is no longer being asserted. If you own the copyright and would like files to be removed, please contact me.

Tape/disk:	Home » Archimedes archive » Zipped Apps » Squirrel
Filename:	squirrel/!Sqlimport/TemplatesB
Read OK:	✔
File size:	0A77 bytes
Load address:	0000
Exec address:	0000

�����\progInfo
*n�[xfer_send
�*[fieldlength
l�nicewerr
�xD=importexec
��data_import
������� ����=���������vH���=a������v���=a������v����=a,�P���v����=a/L(����v����=aOY��������Name

led>
����������Purpose

>
�P��������Author

d>
�����H���Version

>
��������bOwner
n

>
������J���=`�<Untitled>
�4���Td���=�
K
titled>
�About this program
<...>
R2
### Digital Services Ltd ###
R2
Squirrel import utility
R2
� Digital Services Ltd, 1990
R2
SqlImport
R2
�x����R ����=0Save as:


e�H�������=a8;������a@����
P��������=�KLN�������aW��������J8���=`�<Untitled>
�D�����,���=`�<Untitled>
�n���<���=`�<Untitled>
�OK
R6,3
File name:

Pptr_write
icn
�L���� ����=�����
�x��������=���������=� �������Field name
x�������������Field Length

Pptr_write
123456789012345
R2
Field length
�x�t��������=0�����V����L���=1���\������a��� d�������:`!sqlimport
Squirrel Import
OK
R5,3

R2;L40
��"|���� ����=�����0����L���
����V�������5!�����,��$����Tp��� ����=1)*�p���R����9a/8Squirrel Data Import
Number of records
0
R2
100%

R5,3
Finished
R5,3
��,��������=08��������\���:aM����	p��������=�VW ���\d���:ab����
r$����X���=�kl@������wx2�������9Format
ed>
2�������1!{�2P�������31��T��������=���TP��������=���(���(���=1��lT���������Table
se
>
DP���P���������D����P���w�����l���������Source
e
>
Squirrel Data Import
file_xxx

Pptr_write
file_xxx

Pptr_write

R4
Separated
sradiooff,radioon
Tabulated
sradiooff,radioon

Pptr_write
|J
Pptr_write
OK
R6,3
Record separator
Field separator

00000000  ff ff ff ff 00 00 00 00  00 00 00 00 00 00 00 00  |................|
00000010  a4 00 00 00 5c 02 00 00  01 00 00 00 70 72 6f 67  |....\.......prog|
00000020  49 6e 66 6f 0d 2a 6e e0  00 03 00 00 5b 01 00 00  |Info.*n.....[...|
00000030  01 00 00 00 78 66 65 72  5f 73 65 6e 64 0d dc 2a  |....xfer_send..*|
00000040  5b 04 00 00 11 01 00 00  01 00 00 00 66 69 65 6c  |[...........fiel|
00000050  64 6c 65 6e 67 74 68 0d  6c 05 00 00 d8 00 00 00  |dlength.l.......|
00000060  01 00 00 00 6e 69 63 65  77 65 72 72 0d 8a 78 04  |....nicewerr..x.|
00000070  44 06 00 00 3d 01 00 00  01 00 00 00 69 6d 70 6f  |D...=.......impo|
00000080  72 74 65 78 65 63 0d ea  81 07 00 00 f6 02 00 00  |rtexec..........|
00000090  01 00 00 00 64 61 74 61  5f 69 6d 70 6f 72 74 0d  |....data_import.|
000000a0  00 00 00 00 80 01 00 00  d4 00 00 00 fe 03 00 00  |................|
000000b0  08 02 00 00 00 00 00 00  04 00 00 00 ff ff ff ff  |................|
000000c0  12 00 20 84 07 02 07 01  0c 0e 0c 00 00 00 00 00  |.. .............|
000000d0  00 fc ff ff 00 05 00 00  04 00 00 00 3d 01 00 00  |............=...|
000000e0  00 00 00 00 01 00 00 00  00 00 00 00 d8 01 00 00  |................|
000000f0  ff ff ff ff 13 00 00 00  0c 00 00 00 9a 00 00 00  |................|
00000100  14 ff ff ff 76 02 00 00  48 ff ff ff 3d 61 00 17  |....v...H...=a..|
00000110  eb 01 00 00 f1 01 00 00  1e 00 00 00 9a 00 00 00  |................|
00000120  d8 fe ff ff 76 02 00 00  0c ff ff ff 3d 61 00 17  |....v.......=a..|
00000130  f4 01 00 00 11 02 00 00  1e 00 00 00 9a 00 00 00  |................|
00000140  8c ff ff ff 76 02 00 00  c0 ff ff ff 3d 61 00 17  |....v.......=a..|
00000150  14 02 00 00 2c 02 00 00  1b 00 00 00 9a 00 00 00  |....,...........|
00000160  50 ff ff ff 76 02 00 00  84 ff ff ff 3d 61 00 17  |P...v.......=a..|
00000170  2f 02 00 00 4c 02 00 00  28 00 00 00 9a 00 00 00  |/...L...(.......|
00000180  c8 ff ff ff 76 02 00 00  fc ff ff ff 3d 61 00 17  |....v.......=a..|
00000190  4f 02 00 00 59 02 00 00  0c 00 00 00 14 00 00 00  |O...Y...........|
000001a0  c8 ff ff ff 9a 00 00 00  fc ff ff ff 11 02 00 17  |................|
000001b0  4e 61 6d 65 0d 0d 6c 65  64 3e 0d fe 14 00 00 00  |Name..led>......|
000001c0  8c ff ff ff 9a 00 00 00  c0 ff ff ff 11 02 00 17  |................|
000001d0  50 75 72 70 6f 73 65 0d  0d 3e 0d fe 14 00 00 00  |Purpose..>......|
000001e0  50 ff ff ff 9a 00 00 00  84 ff ff ff 11 02 00 17  |P...............|
000001f0  41 75 74 68 6f 72 0d 0d  64 3e 0d fe 14 00 00 00  |Author..d>......|
00000200  14 ff ff ff 9a 00 00 00  48 ff ff ff 11 02 00 17  |........H.......|
00000210  56 65 72 73 69 6f 6e 0d  0d 3e 0d fe 14 00 00 00  |Version..>......|
00000220  d8 fe ff ff 9a 00 00 00  0c ff ff ff 11 62 00 17  |.............b..|
00000230  4f 77 6e 65 72 0d 6e 0d  0d 3e 0d fe 9a 00 00 00  |Owner.n..>......|
00000240  94 fe ff ff 4a 01 00 00  c4 fe ff ff 3d 60 00 c7  |....J.......=`..|
00000250  3c 55 6e 74 69 74 6c 65  64 3e 0d 7f a4 02 00 00  |<Untitled>......|
00000260  34 ff ff ff 54 03 00 00  64 ff ff ff 3d 00 00 b7  |4...T...d...=...|
00000270  0d 4b 0d 74 69 74 6c 65  64 3e 0d fe 41 62 6f 75  |.K.titled>..Abou|
00000280  74 20 74 68 69 73 20 70  72 6f 67 72 61 6d 0d 3c  |t this program.<|
00000290  2e 2e 2e 3e 0d 52 32 0d  23 23 23 20 44 69 67 69  |...>.R2.### Digi|
000002a0  74 61 6c 20 53 65 72 76  69 63 65 73 20 4c 74 64  |tal Services Ltd|
000002b0  20 23 23 23 0d 52 32 0d  53 71 75 69 72 72 65 6c  | ###.R2.Squirrel|
000002c0  20 69 6d 70 6f 72 74 20  75 74 69 6c 69 74 79 0d  | import utility.|
000002d0  52 32 0d a9 20 44 69 67  69 74 61 6c 20 53 65 72  |R2.. Digital Ser|
000002e0  76 69 63 65 73 20 4c 74  64 2c 20 31 39 39 30 0d  |vices Ltd, 1990.|
000002f0  52 32 0d 53 71 6c 49 6d  70 6f 72 74 0d 52 32 0d  |R2.SqlImport.R2.|
00000300  02 00 00 00 b4 02 00 00  10 01 00 00 78 03 00 00  |............x...|
00000310  00 00 00 00 00 00 00 00  ff ff ff ff 52 00 20 84  |............R. .|
00000320  07 02 07 01 0c 0e 02 00  00 00 00 00 00 fc ff ff  |................|
00000330  00 05 00 00 00 00 00 00  3d 00 00 00 00 30 00 00  |........=....0..|
00000340  01 00 00 00 00 00 00 00  53 61 76 65 20 61 73 3a  |........Save as:|
00000350  0d 0d 0d 65 07 00 00 00  c2 00 00 00 48 ff ff ff  |...e........H...|
00000360  08 01 00 00 90 ff ff ff  3d 61 01 17 38 01 00 00  |........=a..8...|
00000370  3b 01 00 00 0c 00 00 00  10 01 00 00 b8 ff ff ff  |;...............|
00000380  16 02 00 00 e4 ff ff ff  11 61 00 17 40 01 00 00  |.........a..@...|
00000390  ff ff ff ff 1e 00 00 00  0a 00 00 00 50 ff ff ff  |............P...|
000003a0  ba 00 00 00 84 ff ff ff  3d f1 00 07 4b 01 00 00  |........=...K...|
000003b0  4c 01 00 00 00 01 00 00  4e 00 00 00 a4 ff ff ff  |L.......N.......|
000003c0  92 00 00 00 ec ff ff ff  19 61 00 17 57 01 00 00  |.........a..W...|
000003d0  ff ff ff ff 0c 00 00 00  9a 00 00 00 08 ff ff ff  |................|
000003e0  4a 01 00 00 38 ff ff ff  3d 60 00 d7 3c 55 6e 74  |J...8...=`..<Unt|
000003f0  69 74 6c 65 64 3e 0d e6  44 00 00 00 fc fe ff ff  |itled>..D.......|
00000400  f4 00 00 00 2c ff ff ff  3d 60 00 d7 3c 55 6e 74  |....,...=`..<Unt|
00000410  69 74 6c 65 64 3e 0d e6  6e 00 00 00 0c ff ff ff  |itled>..n.......|
00000420  1e 01 00 00 3c ff ff ff  3d 60 00 d7 3c 55 6e 74  |....<...=`..<Unt|
00000430  69 74 6c 65 64 3e 0d e6  4f 4b 0d 52 36 2c 33 0d  |itled>..OK.R6,3.|
00000440  46 69 6c 65 20 6e 61 6d  65 3a 0d 0d 50 70 74 72  |File name:..Pptr|
00000450  5f 77 72 69 74 65 0d 69  63 6e 0d 02 00 00 00 b8  |_write.icn......|
00000460  02 00 00 1a 02 00 00 4c  03 00 00 00 00 00 00 00  |.......L........|
00000470  00 00 00 ff ff ff ff 12  00 20 87 07 02 07 01 03  |......... ......|
00000480  01 0c 00 00 00 00 00 00  fc ff ff 00 05 00 00 00  |................|
00000490  00 00 00 3d 01 00 00 00  00 00 00 01 00 00 00 00  |...=............|
000004a0  00 00 00 d8 00 00 00 ff  ff ff ff 0d 00 00 00 04  |................|
000004b0  00 00 00 ee 00 00 00 78  ff ff ff 8c 01 00 00 ac  |.......x........|
000004c0  ff ff ff 3d f1 00 07 e5  00 00 00 e6 00 00 00 06  |...=............|
000004d0  00 00 00 ee 00 00 00 c0  ff ff ff 02 02 00 00 f4  |................|
000004e0  ff ff ff 3d 01 00 17 f1  00 00 00 01 01 00 00 20  |...=........... |
000004f0  00 00 00 1a 00 00 00 c0  ff ff ff e6 00 00 00 f4  |................|
00000500  ff ff ff 11 02 00 c7 46  69 65 6c 64 20 6e 61 6d  |.......Field nam|
00000510  65 0d 7f 18 00 00 00 78  ff ff ff e4 00 00 00 ac  |e......x........|
00000520  ff ff ff 11 03 00 c7 04  01 00 00 ff ff ff ff 0e  |................|
00000530  00 00 00 46 69 65 6c 64  20 4c 65 6e 67 74 68 0d  |...Field Length.|
00000540  0d 50 70 74 72 5f 77 72  69 74 65 0d 31 32 33 34  |.Pptr_write.1234|
00000550  35 36 37 38 39 30 31 32  33 34 35 0d 52 32 0d 46  |56789012345.R2.F|
00000560  69 65 6c 64 20 6c 65 6e  67 74 68 0d fc 00 00 00  |ield length.....|
00000570  78 01 00 00 98 03 00 00  74 02 00 00 00 00 00 00  |x.......t.......|
00000580  00 00 00 00 ff ff ff ff  12 00 00 84 07 02 07 01  |................|
00000590  03 01 0c 00 00 00 00 00  00 fc ff ff 00 05 00 00  |................|
000005a0  00 00 00 00 3d 01 00 00  00 30 00 00 01 00 00 00  |....=....0......|
000005b0  00 00 00 00 b8 00 00 00  ff ff ff ff 10 00 00 00  |................|
000005c0  03 00 00 00 56 01 00 00  18 ff ff ff ca 01 00 00  |....V...........|
000005d0  4c ff ff ff 3d 31 01 17  c8 00 00 00 cb 00 00 00  |L...=1..........|
000005e0  0c 00 00 00 a2 00 00 00  5c ff ff ff 86 02 00 00  |........\.......|
000005f0  ec ff ff ff 1d 61 00 c7  d0 00 00 00 d1 00 00 00  |.....a..........|
00000600  00 01 00 00 20 00 00 00  64 ff ff ff 88 00 00 00  |.... ...d.......|
00000610  c8 ff ff ff 3a 60 00 17  21 73 71 6c 69 6d 70 6f  |....:`..!sqlimpo|
00000620  72 74 0d 7f 53 71 75 69  72 72 65 6c 20 49 6d 70  |rt..Squirrel Imp|
00000630  6f 72 74 0d 4f 4b 0d 52  35 2c 33 0d 0d 52 32 3b  |ort.OK.R5,3..R2;|
00000640  4c 34 30 0d f2 00 00 00  d8 01 00 00 22 03 00 00  |L40........."...|
00000650  7c 02 00 00 00 00 00 00  00 00 00 00 ff ff ff ff  ||...............|
00000660  12 00 20 87 07 02 07 01  03 01 0c 00 00 00 00 00  |.. .............|
00000670  00 fc ff ff 00 05 00 00  00 00 00 00 3d 01 00 00  |............=...|
00000680  00 00 00 00 01 00 00 00  00 00 00 00 f8 00 00 00  |................|
00000690  ff ff ff ff 15 00 00 00  05 00 00 00 30 00 00 00  |............0...|
000006a0  b0 ff ff ff 4c 01 00 00  e4 ff ff ff 11 01 00 c7  |....L...........|
000006b0  0d 01 00 00 ff ff ff ff  15 00 00 00 56 01 00 00  |............V...|
000006c0  b0 ff ff ff d2 01 00 00  e4 ff ff ff 35 03 00 17  |............5...|
000006d0  1f 01 00 00 21 01 00 00  08 00 00 00 dc 01 00 00  |....!...........|
000006e0  b0 ff ff ff 2c 02 00 00  e4 ff ff ff 11 03 00 07  |....,...........|
000006f0  24 01 00 00 ff ff ff ff  05 00 00 00 54 01 00 00  |$...........T...|
00000700  70 ff ff ff 20 02 00 00  a0 ff ff ff 3d 31 01 17  |p... .......=1..|
00000710  29 01 00 00 2a 01 00 00  0c 00 00 00 c2 00 00 00  |)...*...........|
00000720  70 ff ff ff 52 01 00 00  a0 ff ff ff 39 61 00 11  |p...R.......9a..|
00000730  2f 01 00 00 38 01 00 00  0c 00 00 00 53 71 75 69  |/...8.......Squi|
00000740  72 72 65 6c 20 44 61 74  61 20 49 6d 70 6f 72 74  |rrel Data Import|
00000750  0d 4e 75 6d 62 65 72 20  6f 66 20 72 65 63 6f 72  |.Number of recor|
00000760  64 73 0d 30 0d 52 32 0d  31 30 30 25 0d 0d 52 35  |ds.0.R2.100%..R5|
00000770  2c 33 0d 46 69 6e 69 73  68 65 64 0d 52 35 2c 33  |,3.Finished.R5,3|
00000780  0d 0e 01 00 00 f8 00 00  00 d2 03 00 00 2c 03 00  |.............,..|
00000790  00 00 00 00 00 00 00 00  00 ff ff ff ff 12 00 00  |................|
000007a0  87 07 02 07 01 03 01 0c  00 00 00 00 00 00 fc ff  |................|
000007b0  ff 00 05 00 00 00 00 00  00 3d 01 00 00 00 30 00  |.........=....0.|
000007c0  00 01 00 00 00 00 00 00  00 38 02 00 00 ff ff ff  |.........8......|
000007d0  ff 16 00 00 00 0f 00 00  00 18 00 00 00 94 ff ff  |................|
000007e0  ff 5c 00 00 00 d8 ff ff  ff 3a 61 00 17 4d 02 00  |.\.......:a..M..|
000007f0  00 ff ff ff ff 09 00 00  00 70 00 00 00 98 ff ff  |.........p......|
00000800  ff ac 02 00 00 cc ff ff  ff 3d f1 00 07 56 02 00  |.........=...V..|
00000810  00 57 02 00 00 00 01 00  00 18 00 00 00 20 ff ff  |.W........... ..|
00000820  ff 5c 00 00 00 64 ff ff  ff 3a 61 00 17 62 02 00  |.\...d...:a..b..|
00000830  00 ff ff ff ff 0a 00 00  00 72 00 00 00 24 ff ff  |.........r...$..|
00000840  ff ae 02 00 00 58 ff ff  ff 3d f1 00 07 6b 02 00  |.....X...=...k..|
00000850  00 6c 02 00 00 00 01 00  00 18 00 00 00 40 fe ff  |.l...........@..|
00000860  ff ac 02 00 00 f0 fe ff  ff 1d 01 00 c7 77 02 00  |.............w..|
00000870  00 78 02 00 00 0c 00 00  00 32 00 00 00 dc fe ff  |.x.......2......|
00000880  ff a0 00 00 00 08 ff ff  ff 39 00 00 17 46 6f 72  |.........9...For|
00000890  6d 61 74 0d 65 64 3e 0d  7f 32 00 00 00 98 fe ff  |mat.ed>..2......|
000008a0  ff 06 01 00 00 cc fe ff  ff 13 31 21 17 7b 02 00  |..........1!.{..|
000008b0  00 85 02 00 00 19 00 00  00 32 00 00 00 50 fe ff  |.........2...P..|
000008c0  ff 06 01 00 00 84 fe ff  ff 33 31 01 17 97 02 00  |.........31.....|
000008d0  00 a1 02 00 00 0c 00 00  00 54 02 00 00 98 fe ff  |.........T......|
000008e0  ff 96 02 00 00 cc fe ff  ff 3d f1 00 07 b3 02 00  |.........=......|
000008f0  00 b4 02 00 00 10 00 00  00 54 02 00 00 50 fe ff  |.........T...P..|
00000900  ff 96 02 00 00 84 fe ff  ff 3d f1 00 07 bf 02 00  |.........=......|
00000910  00 c2 02 00 00 10 00 00  00 28 02 00 00 e4 fd ff  |.........(......|
00000920  ff ac 02 00 00 28 fe ff  ff 3d 31 02 17 cd 02 00  |.....(...=1.....|
00000930  00 d0 02 00 00 0c 00 00  00 6c 00 00 00 54 ff ff  |.........l...T..|
00000940  ff fa 00 00 00 84 ff ff  ff 11 00 00 c7 54 61 62  |.............Tab|
00000950  6c 65 0d 73 65 0d 3e 0d  7f 44 01 00 00 50 fe ff  |le.se.>..D...P..|
00000960  ff 50 02 00 00 84 fe ff  ff 11 01 00 17 d5 02 00  |.P..............|
00000970  00 ff ff ff ff 11 00 00  00 44 01 00 00 98 fe ff  |.........D......|
00000980  ff 50 02 00 00 cc fe ff  ff 11 03 00 77 e6 02 00  |.P..........w...|
00000990  00 ff ff ff ff 10 00 00  00 6c 00 00 00 c8 ff ff  |.........l......|
000009a0  ff fa 00 00 00 f8 ff ff  ff 11 00 00 c7 53 6f 75  |.............Sou|
000009b0  72 63 65 0d 65 0d 3e 0d  7f 53 71 75 69 72 72 65  |rce.e.>..Squirre|
000009c0  6c 20 44 61 74 61 20 49  6d 70 6f 72 74 0d 66 69  |l Data Import.fi|
000009d0  6c 65 5f 78 78 78 0d 0d  50 70 74 72 5f 77 72 69  |le_xxx..Pptr_wri|
000009e0  74 65 0d 66 69 6c 65 5f  78 78 78 0d 0d 50 70 74  |te.file_xxx..Ppt|
000009f0  72 5f 77 72 69 74 65 0d  0d 52 34 0d 53 65 70 61  |r_write..R4.Sepa|
00000a00  72 61 74 65 64 0d 73 72  61 64 69 6f 6f 66 66 2c  |rated.sradiooff,|
00000a10  72 61 64 69 6f 6f 6e 0d  54 61 62 75 6c 61 74 65  |radioon.Tabulate|
00000a20  64 0d 73 72 61 64 69 6f  6f 66 66 2c 72 61 64 69  |d.sradiooff,radi|
00000a30  6f 6f 6e 0d 0d 50 70 74  72 5f 77 72 69 74 65 0d  |oon..Pptr_write.|
00000a40  7c 4a 0d 50 70 74 72 5f  77 72 69 74 65 0d 4f 4b  ||J.Pptr_write.OK|
00000a50  0d 52 36 2c 33 0d 52 65  63 6f 72 64 20 73 65 70  |.R6,3.Record sep|
00000a60  61 72 61 74 6f 72 0d 46  69 65 6c 64 20 73 65 70  |arator.Field sep|
00000a70  61 72 61 74 6f 72 0d                              |arator.|
00000a77

Our privacy policy is here.
Last updated: 01 May 2025, 21:49 UTC
Website designed by .