[RESOLVED] from text file to access table

[lall]

Using VBA or API?

VBA - functions to read / search:
open
line input
close
eof
left
right
mid <<<< you will probably use this


If your text is always the same (as in fixed length) then you should be able to loop thorugh the file, importing a line, separating it and placing into the fields before closing the file and recordset.


Have a go and post up some code if you can't get it working.

Hi!

Thank you for your reply.
I'm using Visual Basic 6.

Yes, the text is always the same.

I know what should i do, but i just don't have no knowledge about IO commands.

I thought there is a sample to show by someone.