View Single Post
  #1  
Old May 27th, 2010, 11:50 PM posted to microsoft.public.access
StuJol
external usenet poster
 
Posts: 122
Default getting data from a text file

i have an access 2003 database. i have a text file which has loads of
instances of the below text. i want to be able to this data into a table so
for every instance of the word 'description', plance the description text
into the description field. Any help would be great... many thanks...

USER_ALARM NAME="_OAR ALARM"
user="PCSD_TEAM" time=1177594986/* "26-Apr-2007 14:43:06" */
{
DESCRIPTION="Operator Action Request"
ALARM_WORD="OAR"
MESSAGE="%P1 %P2"
CATEGORY="PROCESS"
SUMMARY_NO=7
DEFAULT_PARAM1="OAR/MSG1"
DEFAULT_PARAM2="OAR/MSG1"
WAVE_FILE=""
}
USER_ALARM NAME="_OAR_HORN"
user="PCSD_TEAM" time=1140541360/* "21-Feb-2006 17:02:40" */
{
DESCRIPTION="OAR Time Out Alarm"
ALARM_WORD="_OAR_HORN"
MESSAGE="OAR Time Out"
CATEGORY="PROCESS"
SUMMARY_NO=7
DEFAULT_PARAM1=""
DEFAULT_PARAM2=""
WAVE_FILE=""
}