Converting a CSV file ???

  • Thread starter Thread starter Lynne
  • Start date Start date
L

Lynne

We're from the UK, but follow various sports in the USA. The teams we follow
have produced either a fixture or schedule of forthcoming games or matches.
When we try to import the data into Microsoft Outlook Calendar the format
comes out wrong, due to the day and month being the other way round.

Any tips or answers to how we can get the right format.

Cheers

Lynne
 
Export them to a .csv and massage the order of information to match what you
expect.

--
Milly Staples [MVP - Outlook]

Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
reading.

After furious head scratching, Lynne wrote:

| We're from the UK, but follow various sports in the USA. The teams we
| follow have produced either a fixture or schedule of forthcoming
| games or matches. When we try to import the data into Microsoft
| Outlook Calendar the format comes out wrong, due to the day and month
| being the other way round.
|
| Any tips or answers to how we can get the right format.
|
| Cheers
|
| Lynne
 
You can probably get Excel to do a lot of the hard work for you - I don't
want to go off-topic by straying into Excel/CSV country, but somebody on the
Excel groups should be able to help you if you get stuck.
 
Back
Top