[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

[EquisMetaStock Group] Downloader and Excel problem



PureBytes Links

Trading Reference Links

Hello everyone.

I've been having a problem with date formats and importing into my 
database. If anyone can help, I'd be most grateful.

My vendor has been helping me with a derived-data stream, and sent me 
some history to check, in the form of a .csv file. Problem was, the 
date column was in native format (1/1/1900 = day 1). 

This was a new one to me, but I was told how to convert the data column 
to date format in Excel, and then I tried to import via the Downloader 
into my database. Using my local date format, I came up with a repeated 
DL nag saying 'invalid date', so then I tried the US date format to no 
avail.

I wondered if anyone can help me with this?

Kind regards to all.

D



 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/equismetastock/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/equismetastock/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:equismetastock-digest@xxxxxxxxxxxxxxx 
    mailto:equismetastock-fullfeatured@xxxxxxxxxxxxxxx

<*> To unsubscribe from this group, send an email to:
    equismetastock-unsubscribe@xxxxxxxxxxxxxxx

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/