<div dir="ltr">It's even worse when the database you are converting from also needs to be completely re-written, normalized and logical to improve it and even worse yet when the old database is still being used...<br><br>
<div class="gmail_quote">On Wed, Aug 13, 2008 at 6:52 PM, Barry G. Sumpter <span dir="ltr"><<a href="mailto:barry@noodlebox.com.au">barry@noodlebox.com.au</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Solved.<br>
<br>
I used excel and formatted date columns in dd/mm/yyyy format.<br>
Then saved to .csv<br>
And imported with vStudio into a VarChar(200) fields table.<br>
Then wrote an INSERT INTO / SELECT query.<br>
Once I got it into VStudio it was easier.<br>
<br>
I wonder now that I'm writing this if we can add a mapping listbox<br>
To use like the import date into a table procedure.<br>
Where we would be able to define the new table layout and save it<br>
Etc..<br>
<br>
<br>
Is it me or is data conversions from one DB to another a pain.<br>
Not just field types but field matching as well.<br>
It's not a next day delivery kind of project.<br>
I'm thinking it's the grunt end of IT.<br>
<br>
<br>
Thanks,<br>
<font color="#888888"> Barry G. Sumpter<br>
</font><div><div></div><div class="Wj3C7c"><br>
<br>
<br>
-----Original Message-----<br>
From: valentina-studio-bounces+barry=<a href="http://noodlebox.com.au" target="_blank">noodlebox.com.au</a>@<a href="http://lists.macserve.net" target="_blank">lists.macserve.net</a><br>
[mailto:<a href="mailto:valentina-studio-bounces%2Bbarry">valentina-studio-bounces+barry</a>=<a href="http://noodlebox.com.au" target="_blank">noodlebox.com.au</a>@<a href="http://lists.macserve.net" target="_blank">lists.macserve.net</a>]<br>
On Behalf Of Ruslan Zasukhin<br>
Sent: Thursday, 14 August 2008 4:16 AM<br>
To: <a href="mailto:valentina-studio@lists.macserve.net">valentina-studio@lists.macserve.net</a><br>
Subject: Re: .csv Dates in 20-Oct-06 fomat won't import/translate into<br>
VStuido<br>
<br>
On 8/13/08 3:36 AM, "Barry G. Sumpter" <<a href="mailto:barry@noodlebox.com.au">barry@noodlebox.com.au</a>> wrote:<br>
<br>
Hi Barry.,<br>
<br>
IMPORTANT to understand:<br>
<br>
When data are stored INSIDE of db, they do not have any format!<br>
Format of string plays only when numbers are converted to/from strings<br>
<br>
> In VStuido I've got a VarChar field which contains a date in the format of<br>
> 20-Oct-06.<br>
<br>
Field DO NOT contains it in this format.<br>
it only convert to it on the fly to display<br>
<br>
<br>
> It's the only way I could get the data in a VStuido DB.<br>
><br>
> VStuido can't translate the data by simple changing the field type to<br>
date.<br>
><br>
> Does anyone have a SQL statement to change the format into 20/08/2006 ?<br>
<br>
Select database in Schema Editor<br>
In the property inspector -- should be few parameters related to date/time<br>
format/ Check them<br>
<br>
--<br>
Best regards,<br>
<br>
Ruslan Zasukhin<br>
VP Engineering and New Technology<br>
Paradigma Software, Inc<br>
<br>
Valentina - Joining Worlds of Information<br>
<a href="http://www.paradigmasoft.com" target="_blank">http://www.paradigmasoft.com</a><br>
<br>
[I feel the need: the need for speed]<br>
<br>
<br>
_______________________________________________<br>
Valentina-studio mailing list<br>
<a href="mailto:Valentina-studio@lists.macserve.net">Valentina-studio@lists.macserve.net</a><br>
<a href="http://lists.macserve.net/mailman/listinfo/valentina-studio" target="_blank">http://lists.macserve.net/mailman/listinfo/valentina-studio</a><br>
<br>
_______________________________________________<br>
Valentina-studio mailing list<br>
<a href="mailto:Valentina-studio@lists.macserve.net">Valentina-studio@lists.macserve.net</a><br>
<a href="http://lists.macserve.net/mailman/listinfo/valentina-studio" target="_blank">http://lists.macserve.net/mailman/listinfo/valentina-studio</a><br>
</div></div></blockquote></div><br><br clear="all"><br>-- <br><a href="http://www.bluewatermaritime.com">http://www.bluewatermaritime.com</a><br>
</div>