Export data in table to text file

  • Thread starter Thread starter van
  • Start date Start date
V

van

Hi All

Hopefully someone can point me in the right direction.

I would like to export all of the data in a table into a text file. I have
been thru the File\export screens, however this does not provide what I am
looking for. For instance I have 4 columns in the table, but the text file
I require has 8 arguments to it. One is a figure I do not require in the
table, but I do in the text file, it is a static number and will remain the
same for every record. Another is the day, which is not req'd in the table
either, but is in the txt file. But the date is stored in both, and thus can
be used to determine the day. The other 2 figures are of a similar nature.

Do I need to create a macro or a new export specification? If it is the
latter, how is this done? I would like if possible not to have to enter
this information into the table, as its not needed.

Thanks
 
don't mess the your table. instead do a query. you can add
the necessary extra data columns needed for the text file
there. then do a macro using the transfer text method to
send the query results to the text file.
 
Back
Top