View Single Post
  #2   Report Post  
Earl Kiosterud
 
Posts: n/a
Default

D,

No mapping that I know of -- but easily done with macro programming. There
are multiple ways to read a text file into a sheet, depending in part on the
version of Excel you're using. Check out
http://www.smokeylake.com/excel/textfiles.htm

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"D" wrote in message news:HdXjd.244895$a85.37719@fed1read04...
Hey guys- been searching for a while now, and all the posts are a little
more complex than I think this needs to be. Can you help?

Basically, I have a CSV file that I need to import into another 'Template'
file. But- here's the key- not EVERY column in the CSV file needs to
import into my template. Also, the columns in the CSV file are NOT in the
same order they need to be in the Template file. So, I need to be able to
pick and choose which columns import and go where. Does that make sense?
Is there an easy 'import mapping' system to use or any other way to do
this? Like I said, everything Im seeing is looking pretty complicated-
more than I think it needs to be. This seems as if it'd be fairly easy to
accomplish, I'm just not finding answers I need.
Thanks for any help.
D