Hello all. I have a comma delimited file named poskip.csv. I would like to read this file and put the contents into a message box, but am not sure of the best way to do this. My file would look like the following:

1, 4, 7, 25

and I would like to create a message box that says "The following orders could not be processed at this time: PO 1, PO 4, PO 7, and PO 25." Do I import this file into a temporary table, and then loop through the records to come up with this, or is there an easy way to do this using only VBA?

Thanks for any help,
Kevin

Kevin,

I would read the Access help on the Split Function (to split the comma-delimited text into an array of values).

With this tool, you can split the comma-delimited data into an array of values. From there, you can assemble the string to be displayed in the textbox by looping through the array of values.

Hope this helps,

Dennis

Thanks to both of you. I was able to get the contents of the file using Doug's suggestion, and then was able to split it into an array using the recommendation from Dennis so I could customize the message box a little bit more. When I was researching the Split function I came across a different way of getting the file contents into a string. Is there any benefit of using the following instead of the technique Doug gave?



It seems that it accomplishes the same thing. Is one better, or more reliable than the other?

Thanks for the help,
Kevin