Importing Delimited Files

[John W]

I'm trying to import data that is in a delimited format and I'm wondering if
Access can do what I'm needing. The file starts out with a header section
seperated by asterisks. After coming to a specific set of letters in the
file there will be information that belongs under that header. This will be
seperated by both * and ~. The file will continue on and have another
header section followed by more information belonging with the second
header. I'm needing to import several files into Access, sort them to match
their appropriate header (information belonging to a certain header will
come from multiple files). I then need the sorted data put back into text
files with the asterisks and tilde added back in.

First is this possible in Access or am I wasting my time. Second - how will
I handle a file that has two types of seperators and also needs to watch for
specific letters that will indicate new sections.

Thanks for any information you can give me!

 

[Roger Carlson]

Certainly, but you'll have to read the file a link at a time and parse the
fields yourself programmatically.

On my website (www.rogersaccesslibrary.com), are several Access database
samples that might help. Look for "ImportLineInput.mdb",
"ImportToTempDatabase.mdb", "UpdateImportSeekFind.mdb". None of these
scenarios exactly match yours, but they should give you a start.
--
--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

 

[John W]

Thanks Roger. There's enough examples here to give me something to start
with.

 

[Roger Carlson]

Great!

Thanks Roger. There's enough examples here to give me something to start
with.