Auto-populate Tables

  • Thread starter Thread starter AFKAFB
  • Start date Start date
A

AFKAFB

I've been asked to generate some text files from my DB.
Thats not an issue.
However, the requirement is that the data should auto-populate the
output file (it will be saved as a text file).
This confuses me.
My plan was to run a query to extract the data and to save as a test
file but the analyst is suggesting that i should be able to
AUTO-Populate the tables.
Apologies for the lack of exact information but this really confuses
me.
regards
chris
 
Chris,

Yep, I'm confused too. You will need to clarify the requirement. If
the meaning is for the data export to the text file to be automated in
some way, i.e. to occur by clicking a button on a form, or at a certain
time of the day, or some such like that, then you will be able to use a
TransferText macro or TransferText method in a VBA procedure.
 
Are you saying that you need to add each record to the text file as you add
it to Access? You can link to a text file using File -> Get External Data ->
Link Tables & pick Files of Type: Text files. However, this would put the
data into the text file, not into the Access table. To get it into both
place, I guess you could bind your form fields to the table fields, and in
the Form_AfterUpdate, append the same record to the linked text file using an
append query that filters to the record on your form.

Or, do you need to export a batch of records at some given point? If this is
the case, use the TransferText method (see the help files for details) on a
button click.
 
Back
Top