import CSV schedule with different time zone

[Ammammata]

the file to be imported is LA Lakers schedule, here:

http://www.nba.com/lakers/schedule/import_schedule.html

http://i.cdn.turner.com/nba/nba/.element/media/2.0/teamsites/lakers/media/l
akers1213.csv

I have two main problems:
- every date field is formatted M/D/Y, but I can sort this out easily
- time is Pacific or Atlantic, I need to convert into my timezone, Italy

Is there any procedure to tell Outlook to change timezone while importing
(and change also the date when necessary)?

 

[Char Jackson]

the file to be imported is LA Lakers schedule, here:

http://www.nba.com/lakers/schedule/import_schedule.html

http://i.cdn.turner.com/nba/nba/.element/media/2.0/teamsites/lakers/media/l
akers1213.csv

I have two main problems:
- every date field is formatted M/D/Y, but I can sort this out easily
- time is Pacific or Atlantic, I need to convert into my timezone, Italy

Is there any procedure to tell Outlook to change timezone while importing
(and change also the date when necessary)?

It would be trivial to modify the csv file *before* importing it into
Outlook rather than *during* that import. Why not do it that way?

Load it into any csv-aware program, make the changes, save the
modified file, then import it into Outlook. I used MS Excel, but there
are other options. Even a simple text editor will work in a pinch.
It's just a text file, after all.

 

[Ammammata]

Il giorno Wed 22 Aug 2012 10:48:50a, *Char Jackson* inviava su
microsoft.public.outlook.general il messaggio
Vediamo cosa scrisse:

It would be trivial to modify the csv file *before* importing it into
Outlook rather than *during* that import. Why not do it that way?

Load it into any csv-aware program, make the changes, save the
modified file, then import it into Outlook. I used MS Excel, but there
are other options. Even a simple text editor will work in a pinch.

exactly what I did, using OO Calc because Excel saves using semicolon
instead of comma to separate fields

yes, semicolon is the default in my system but Outlook wants a comma: we
are lucky that both windows and outlook come from the same company
otherwise...