Colin,
I did not read the entire thread - so someone may have shared this already.
You might be able to use the _VFP.DataToClip() function to paste a cursor in an excel sheet. It saves a bunch of time (as opposed to doing it one cell at a time!).
A PDF at:
http://www.experts-exchange.com/Manager/Databases/FoxPro/Q_20659018.htmlon page 14 there is an example.
HTH
>Hi
>
>I am inserting data into an Excel spreadsheet. It works fine except for the date. I am using dd/mm/yyyy
>
>If I pass Excel 26/01/2003 it is quite happy
>
>But If I pass it 01/07/2003 it doesnt seem to be able to work out which date it is. (ie Jan 7th or July 1st)
>
>What can I do about it?
>
>Colin
Imagination is more important than knowledge