Importing text file to access

[Rod]

I need to import only a portion of a text file into a
record in the database. ie:
ID number: 10
Name: Rod
Telephone: 564-8978
I want 10, Rod, 564-8978 inserted into three different
fields named ID, name, telephone

Please help

Thanks,

 

[John Nurick]

Hi Rod,

It's not clear from your message what your textfile is like. Is it just
the three lines
ID number: 10
Name: Rod
Telephone: 564-8978

Is it a series of multiline records each of which consists of a number
of "name: value" pairs? If so, what indicates where one record ends and
the next begins?

Or is it something else again? How many records are there? Do you want
to import all the records into your table, or just the one whose ID is
(say) 10?

I need to import only a portion of a text file into a
record in the database. ie:
ID number: 10
Name: Rod
Telephone: 564-8978
I want 10, Rod, 564-8978 inserted into three different
fields named ID, name, telephone

Please help

Thanks,

John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.