Linked table to text file - can the file be modified?

[cjashwell]

Hi all. Does anyone know if there is any way to programmatically modify both the structure and the data of a text file that is a linked table in Access?

I have a file of >900k records that is linked as a table in Access (version 2003 on Windows XP SP2) . The file is a structured CSV file with quotes as text qualifiers. I want to add two columns, an integer field so I can add a numeric index, and a 4-char text field which I want to populate with one of three different codes depending on conditions in the data.

Is this possible, or will I have to import the file into Access, make the modifications, and then re-export it?

Thanks in advance for any help anyone can give.

 

[kjv1611]

See if this gets you started:
faq705-3566

--

"If to err is human, then I must be some kind of human!" -Me

 

[kjv1611]

And here is some code given in another forum where the person wanted to replace certain characters within the text file. It may also give you some good info:

http://www.programmersheaven.com/mb/vba/368555/368555/read-and-write-to-csv-file/

--

"If to err is human, then I must be some kind of human!" -Me