On 13 Jan 2013, at 1:38am, Ted Heng <[email protected]> wrote: > Thanks for all the help. I was able to get my SQLite database imported from > the dump file after correcting several issues with the exported SQL > statements like VARCHAR with no length and a few other stuff. The fact that > I have to use REAL for DATETIME field will be an issue, but I'll have to try > to work around it.
Glad it works, Ted. Once you have your data in SQL Server I bet you can figure out a SQL 'UPDATE' command which will convert the datetime fields into the format you want. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

