[greenstone-users] Simple database
| From | Stephen DeGabrielle |
| Date | Tue, 28 Jun 2005 16:08:25 +0930 |
| Subject | [greenstone-users] Simple database |
| Hi, This may seem like a dumb question but how do I import a simple table of records? - I foolishly tried ExcelPlug - not realising that that wold make two very nice html pages (Duh!) My example consists of four columns; 'Title' , 'Source' , 'Date Journal Info' , 'Subject' I have it as a (pair) of Excel tables (just because I have 90k records and Excel maxes out at 64k rows) Any Ideas? Stephen De Gabrielle --- Example data a singel record; (4 fields) "$15000 History award" NT NEWS 29(152): 6 AUG 1980; 2 NORTHERN TERRITORY HISTORY AWARDS Note that the "29(152): 6 AUG 1980; 2" is the Date Journal Info field. the first few (note that this is sorted - not all titles are quoted - but many do start with a non-alpha character ---- Title Source Date Journal Info Subject "$15000 History award" NT NEWS 29(152): 6 AUG 1980; 2 NORTHERN TERRITORY HISTORY AWARDS "$l000 better off' on first homes NT NEWS 30(169): 27 AUG 1981; 3 HOUSING "A great concern" Chief NT NEWS 28(9): 20 FEB 1979; 9 YOUTH EMPLOYMENT "All up" Air Mail: Darwin agitation NORTHERN STANDARD (3): 10 JAN 1939; 6D WESTON, J. "All up" Air Mail: Darwin agitation NORTHERN STANDARD (3): 10 JAN 1939; 6D AIR MAIL SERVICE "Allocate more to road funds"' NT NEWS 38(152): 3 AUG 1989; 2 FEDERAL AID TO TRANSPORTATION "ALP Leadership Rift" NT NEWS 29(153): 7 AUG 1980; 1 AUSTRALIAN LABOR PARTY NORTHERN TERRITORY BRANCH "ALP Leadership Rift" NT NEWS 29(153): 7 AUG 1980; 1 AUSTRALIAN LABOR PARTY NORTHERN TERRITORY BRANCH "Bonanza future" for Northern Territory NT NEWS 29(151); 5 AUG 1980; 3 NORTHERN TERRITORY DEVELOPMENT CORPORATION "Bonson Bites Back" by Jane Sullivan. V Bonson wins 1980 title NT NEWS 29(149): 1 AUG 1980; 2 BAREFOOT MUDCRAB TYING CHAMPIONSHIP "Brainwashing charge" NT NEWS 28(21): 8 MAR 1979; 8 NORTHERN LAND COUNCIL "Calling all artists" NT NEWS 7 AUG 1980; 2 CALTEX ART AWARDS "Cheap stunt" over trees - Bob Tormey NT NEWS 29(47): 2 APR 1980; 2 KEEP AUSTRALIA BEAUTIFUL COUNCIL "College fears domination" - Fred McCue "Empire building by bureaucrats" NT NEWS 29(150): 2 AUG 1980; 2 DARWIN COMMUNITY COLLEGE "Crash car 'turned in air'" NT NEWS 29(153): 7 AUG 1980; 2 KETONEN, SEPPO "Crowd copped it again" NT NEWS 29(151): 5 AUG 1980; 7 FANNIE BAY RACECOURSE "Dalgety's duck has retired" NT NEWS 29(154): 8 AUG 1980; 7 LILLERCRAPP, DOUG "Darwin lagging in Airways growth" NT NEWS 29(150): 2 AUG 1980; 3 AIR TRANSPORT "Darwin's history on show" NT NEWS 29(153): 7 AUG 1980; 10 NATIONAL TRUST OF AUSTRALIA NORTHERN TERRITORY DIVISION "Do away with water meters" NT NEWS 29(149): 1 AUG 1980; 1 WATER "Do away with water meters" NT NEWS 29(149): 1 AUG 1980; 1 BROWN, GEORGE | |