I have an Access table with personal information (e.g., first name, last name,
birth date, etc.) for thousands of people. The table is sorted by state. I
want to be able to run a macro on that table that will create separate pipe
delimited text files for each state with all fields included.

Any help would be appreciated?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...eries/201005/1