I have an emergency conversion from an Access database to SQL.
Even in an emergency, you may have to do this in two stages.
Assuming that you can't use the original table, then I would:
1. process the existing table by picking up the string that represents your date and using VBScript to build a new column that represents the datetime as an integer, and then
2. convert this table, using your new column as the datetime.
Maybe it doesn't appear to be quick, but I prefer sure to swift.
Regards, David
____ � The WDVL Discussion List from WDVL.COM � ____
To Join wdvltalk, Send An Email To: mailto:[EMAIL PROTECTED] Send Your Posts To: [EMAIL PROTECTED]
To change subscription settings to the wdvltalk digest version:
http://wdvl.internet.com/WDVL/Forum/#sub
________________ http://www.wdvl.com _______________________
You are currently subscribed to wdvltalk as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED]
