Hi,



need some help on writing a code that reads the context of a .txt file, 

and import it into a table containing several fields.



The file looks like this:





*******     ********     *******

*******     ********     *******



And so on. I don't want to use the import routine in Access, rather I want 

to have a command-button that does the import for me.



How do I establish the connection between Access and the .txt-file, and 

how do I read the content of the file into the different fields in the 

table?



Anybody?

Go to help and search  TransferText Method



John Ruff - The Eternal Optimist :-)







-----Original Message-----

From: rene sitter [mailto:rsi@f...] 

Sent: Monday, November 26, 2001 12:21 PM

To: Access

Subject: [access] File import





Hi,



need some help on writing a code that reads the context of a .txt file, 

and import it into a table containing several fields.



The file looks like this:





*******     ********     *******

*******     ********     *******



And so on. I don't want to use the import routine in Access, rather I

want 

to have a command-button that does the import for me.



How do I establish the connection between Access and the .txt-file, and 

how do I read the content of the file into the different fields in the 

table?



Anybody?

---

You are currently subscribed to access as: papparuff@c... To

unsubscribe send a blank email to $subst('Email.Unsub')