[sqlite] Import data in SQLite from excel using C# code

[Deepti Marathe]

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...@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[Mohd Radzi Ibrahim]

Hi,
Try use www.libxl.com that has C/C++/C#/Delphi interface to read excel files. The rest are just normal sqlite commands.

[Deepti Marathe]

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.

--
View this message in context: http://old.nabble.com/Import-data-in-SQLite-from-excel-using-C--code-tp31253267p31311644.html

[Simon Slavin]

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.