Data Import w/ Multiple types of delimiters

  • Thread starter Thread starter John W
  • Start date Start date
J

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!
 
Yes, it would have to be done through VBA (Visual Basic for Applications,
which is what Access uses, not VB)
 
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.
 
Back
Top