transfer selected data from text file to Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I need help with this. I have text files containing a whole list of
information. But I would like to select specific datas from the whole list to
be transfered automatically to my Access form's fields.

Thanks alot!
 
Hi Charlene,

I'm not sure what you mean by "a whole list of information". If these
are ordinary text files of data, try this:

1) Use File|Get External Data|Link to create a linked table connected to
the text file.

2) Create an ordinary Select query that gets its data from the linked
table and includes only the fields you need. If you only want some of
the rows from the linked table, set the appropriate criteria.

3) Once the Select query is selecting the data you need, turn it into an
Append query (by selecting Append Query... from the Query menu). Set it
to append its data to the table on which your Access form is based. For
each field in the query, select the appropriate field in the destination
table.

4) Run the query.

5) Delete the linked table.

If there's something unusual about the files, you'll need to explain it.
 
Back
Top