Greetings, Baskaran, Regarding: "SQLite ODBC driver takes hours for data transfer and most of the time it is not success."
Rather than folks on the list providing method after method, it might be helpful for you to give some further information, such as: -- Just approximately, how much data are you converting regularly. I.e., how many megabytes , tables, and rows are involved? -- You mention that you are now doing this "manually". Could you elaborate? Does this mean you're dumping the data to some text format, then importing into sqlite with, perhaps the sqlite3.exe command-line-tool? If so, might simply adding a batch script to this process give you the automation you need? -- How long does the manual conversion take to run? -- Have you determined which of your tables is giving you the problem? How far into your conversion are you getting? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users