Your file is in the wrong format for automatically importing to Access.
You need to get your file into a format like a spreadsheet where you have
the field names going across and the value for each field below the heading.
Each field should either have a fixed width or you can have the fields
separated by commas or some other delimiter.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime".


"stujol" wrote:

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=""
}