View Single Post
Old 09-29-2015, 11:34 AM   #2
MarkK
Super Moderator
 
MarkK's Avatar
 
Join Date: Mar 2004
Location: Vancouver BC
Posts: 7,761
Thanks: 10
Thanked 1,290 Times in 1,227 Posts
MarkK is a name known to all MarkK is a name known to all MarkK is a name known to all MarkK is a name known to all MarkK is a name known to all MarkK is a name known to all
There are many possibilities here. Pre-process the file, so write code that removes commas from each line after the fourth comma. Then your data is correctly delimited--and add the commas back into the address after it's in a table. Or replace the first four commas with some other delimiter and then read in that file. Or, with your code that reads each line, store the records into the table straight from that loop, so grab the first four fields one at a time, then whatever is left is the address.

I would say the ways you can do this are only limited by your programming skill and imagination. How is your programming?
__________________
formerly known as lagbolt | Windows 10 | Access 2010 | Visual Studio 2013 | "Institutions have a vested interest in perpetuating the problems to which they are the solution." - Clay Shirky
MarkK is offline   Reply With Quote