View Single Post
  #4   Report Post  
NickHK
 
Posts: n/a
Default

D,
You could query the text file then.
Check out Dataget External dataNew database query and tailor to your needs
for the text file.

NickHK

"D" wrote in message news:MBXjd.245050$a85.38010@fed1read04...
Hmmm- not sure about this. Someone was telling me about 'linking' files or
columns from one sheet to another. Is this easily done and can work in my
situation? How do I do it if it can work?
thanks
D


"Earl Kiosterud" wrote in message
...
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