New access user needing help! I'm thinking I need to create a module using VBA scripting to accomplish this task.

I have created a view of data from two tables and need to produce a line of text to a text file whenever data is populated in view from the tables. So I only need to create lines of output text for the new lines.

view DATA2Export

Field 1 Field 2 Field 3
------- ------ -------
11225 12TA8 C56

Output string to a file (i.e., C:\export.txt)
"11225","12TA8","C56"

This is being added to an Access97 database (that I can not convert to a newer version, without breaking the front end application).

Thanks in advance for your replies

I do something similar from one of my applications.

I create a text file for the day if one doesn't exist. I use the date in the text file name, and then check for the file using a known name for the day, and if it doesn't exist, I create it.

Then I open it and write one line to it using VBScript from Access. The psuedo code is like:

Create scripting file system object
Check if today's file exists
   If no, create today's file
   Write one line
   Close file
   If yes,
   open file
   write one line
   Close file

This doesn't include whatever you are doing to generate your one line.

I did another similar post on writing to a text file earlier this week. Find that to get started, or post back. I may not be able to get back till Monday.

Look up Scripting.FileSystemObject at MSDN as well.

mmcdonal

Look it up at: http://wrox.books24x7.com