Re: [sqlite] Import data in SQLite from excel using C# code
On 4 Apr 2011, at 7:12am, Deepti Marathe wrote: > From what I see in the examples in libxml, I can read an excel file in my > program, but I still cannot figure out how to upload that file(the data in > that file) to a table in SQlite. Use the data from that table to create the appropriate 'INSERT' commands. http://www.sqlite.org/lang_insert.html PS: When posting, please add your own new text after the text you're replying to. That way we know what you're talking about. Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Import data in SQLite from excel using C# code
>From what I see in the examples in libxml, I can read an excel file in my program, but I still cannot figure out how to upload that file(the data in that file) to a table in SQlite. Mohd Radzi Ibrahim wrote: > > Hi, > Try use www.libxl.com that has C/C++/C#/Delphi interface to read excel > files. The rest are just normal sqlite commands. > > > On 28-Mar-2011, at 9:17 AM, Deepti Marathe wrote: > >> >> Hi, >> >> I am new to SQLite and am using it for the first time. I need to create >> an >> application using C# that will export the data from EXCEL to SQLite. >> Please >> can anybody guide me. >> Thanks in advance! >> >> -- >> View this message in context: >> http://old.nabble.com/Import-data-in-SQLite-from-excel-using-C--code-tp31253267p31253267.html >> Sent from the SQLite mailing list archive at Nabble.com. >> >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > -- View this message in context: http://old.nabble.com/Import-data-in-SQLite-from-excel-using-C--code-tp31253267p31311644.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Import data in SQLite from excel using C# code
Hi, Try use www.libxl.com that has C/C++/C#/Delphi interface to read excel files. The rest are just normal sqlite commands. On 28-Mar-2011, at 9:17 AM, Deepti Marathe wrote: > > Hi, > > I am new to SQLite and am using it for the first time. I need to create an > application using C# that will export the data from EXCEL to SQLite. Please > can anybody guide me. > Thanks in advance! > > -- > View this message in context: > http://old.nabble.com/Import-data-in-SQLite-from-excel-using-C--code-tp31253267p31253267.html > Sent from the SQLite mailing list archive at Nabble.com. > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Import data in SQLite from excel using C# code
Hi, I am new to SQLite and am using it for the first time. I need to create an application using C# that will export the data from EXCEL to SQLite. Please can anybody guide me. Thanks in advance! -- View this message in context: http://old.nabble.com/Import-data-in-SQLite-from-excel-using-C--code-tp31253267p31253267.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users