csv file auto save to excel

[jerry28ph]

I have folder of my company's phone server and it consist of files save as CSV. I need to get a day to day file from the server (saved in csv type) and I want it to auto open and save to excel. Please if you have an idea, i need you help on this. On my access form, i will supply the date of the day that I will need to get from the server.
Thanks.

 

[namliam]

??? WHY ???

CSV is so much better in so many ways... WHY ???

 

[jerry28ph]

Hi Namliam,

Ok the reason why is when im importing CSV files from the server using import table from access, the field name on my table (Call Start which Date/Time data type) always giving me an empty data, but the rest of the field names were okey. I tried to open the csv file manually in excel I saved it then it turned ok after I imported the csv file. I thought i should open it first in excel before importing into my access table. Im sure my problem is the data type of my field name "call start". Do you have an idea how can solve this?
Please need your help.

??? WHY ???

CSV is so much better in so many ways... WHY ???

 

[namliam]

IMHO doing csv > Excel > Access is a VERY bad thing and should be avoided at all costs.

The lost date information is probably because access is having trouble converting the date into a real date. What format is the date?
Alternatively you could change the date field into a text field upon import and use a 'more inteligent' function to convert the date-string into a date.