Converting data.

5 posts / 0 new
Last post
Last seen: 3 months 1 week ago
Joined: 2009/07/21 - 18:15
Converting data.


I have downloaded one of the monthly spot files ( .csv ) and imported it into Open Office, which I am told, is Excel compatable.
Not being very familiar with Databases, I am having difficulty in getting the Date/Time column right.I realise it has to me formatted, but am unsure of how to do it.
Can anyone give me a step-by-step guide please?

Thanks, Roger G0IUW