Imorting a txt file with no line breaks

[chris thorn via AccessMonster.com]

Hi all

I am importing a text file that has fields delimited with a "|" and the end of the record is denoted with a "@"
Ther are no line breaks i.e. The data is presented as "|smith |ron |12345|@|jones | barry |67892|@" a new record is not started on each line. How can I automate the import of such a file? I cannot see any feature in the import wizard that shows an end of record.

Thanks

Chris

*****************************************
* This message was posted via http://www.accessmonster.com
*
* Report spam or abuse by clicking the following URL:
* http://www.accessmonster.com/Uwe/Abuse.aspx?aid=a8e1e2bd1d8e4bfc8c982e02281a244f
*****************************************

 

[Douglas J. Steele]

You won't be able to use the import wizard for that.

You'll either have to change the text file before you try to import it, or
write VBA code to use basic file I/O (Open, Get, etc.) to read the text in
so that you can parse it and write it to the database yourself.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

Hi all

I am importing a text file that has fields delimited with a "|" and the

end of the record is denoted with a "@"

Ther are no line breaks i.e. The data is presented as "|smith |ron

|12345|@|jones | barry |67892|@" a new record is not started on each
line. How can I automate the import of such a file? I cannot see any feature
in the import wizard that shows an end of record.

 

[chris thorn via AccessMonster.com]

Could you give me a sample of the code I would need?

*****************************************
* A copy of the whole thread can be found at:
* http://www.accessmonster.com/Uwe/Forum.aspx/access-externaldata/6991
*
* Report spam or abuse by clicking the following URL:
* http://www.accessmonster.com/Uwe/Abuse.aspx?aid=be837c84f1b14ef9a651d349fc9465d3
*****************************************

 

[linyuhao913]

wo xing ni