Extracting Delimited Data from an Online Source

O

OlYeller21

I have survey data that is being put into a .db file and is delimited
with a "|" symbol. I normally just copy the data from the website,
copy it into a text file, then open it with excel and indicate the
delimiter. Is there a way to have excel read this data from the
website automatically and display the data? I also do a little
manipulation of the data as far as moving one cell to a different
position and inserting a cell somewhere else. I can do that later but
getting it in automatically would save me a little time. Thanks
Zach
 
Top