Data Import w/ Multiple types of delimiters

[John W]

I'm working on a database that will import files that contain multiple types
of delimiters (~, * & ^). Each of the different types of delimiters
indicate the start of a different section. How do I specify that there is
more than one type of delimiter? Everything I see only allows one type.
Does this have to be done through VB?

Thanks!

 

[Douglas J. Steele]

Yes, it would have to be done through VBA (Visual Basic for Applications,
which is what Access uses, not VB)

 

[John W]

I had a feeling that's what you were going to say. It's been a while since
I've used any Visual Basic. Any recommendations for a good thorough book
that would help. I've done programming in the past but it's been several
years and I don't remember a whole lot.

 

[Douglas J. Steele]

For lists of good books, see what Jeff Conrad has at
http://www.accessmvp.com/JConrad/accessjunkie/resources.html#Books

If you're going to be doing a lot of coding, the Access Developer's Handbook
http://www.developershandbook.com/ is a must-have.

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "ImportLineInput.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L