Pinar,
See the earlier thread "Easiest Way to do this Importing method?"

NickHK

"pinar" wrote in message
...

Hi,
In the database i have csv files, but they are in text format. and each
month i have to change them to excel with "text to column" and then i
need to insert a new column and in this column i use vlook function.
each month in the database a new csv file forms. is it possible to
upload the csv file automatically to excel. is it possible to upload
the new data which comes from csv to excel file that i formed before?
is there a way without writing macro?
thanks a lot..
pinar


--
pinar
------------------------------------------------------------------------
pinar's Profile:
http://www.excelforum.com/member.php...o&userid=16067
View this thread: http://www.excelforum.com/showthread...hreadid=276905