I need to grab a text file generated by a script on another server (from a mySQL db)<BR><BR>it looks like Name; ID; URL; so:<BR><BR>Bob; 43; http://;<BR>Frank; 18; http://;<BR>Joe; 32; http://;<BR><BR><BR>How would be the most effecient way to get this into a database on my server?<BR><BR>So 2 part question:<BR><BR>Save file from another server<BR><BR>and<BR><BR>Input a ; delimited text file into an access database<BR><BR>I don&#039t think I can do split(MyFile,";") and cycle through lol