working with tables

[99mel]

i'm wanting to work with tables in Access in a program (vba). I am wanting to read a plain text file with data in it. Then i want to put this data into a table in Access. Anyone any ideas? I'm then wanting to do things with the data and various other stuff until I put the modifyed data into a new text file.<br>
<br>
Thanks for any help.

 

[Zelandakh]

import the file into a temporary table that has one field that is text 255 (if file has up to 255 char lines) or memo if not.<br>
<br>
Then use a module to read the file line by line and work on the data that way. You could read it into an array if that is more useful or drop it after you work on it to another table. Once in the output table, export the data to a text file.<br>
<br>
I once had a module that did this all (years ago) that I can dig out if it helps.

 

[Dreamboat]

Seems to me you could accomplish this task alot easier with Excel.