Export and Import SQLite data from LC Project?

[Mark Schonewille]

Hi John,

Can't you transfer the entire database file? If not, you can just do a dump and import the resulting file or do a query and save the data to a text file, which you import the usual way.

--
Best regards,

Mark Schonewille

Economy-x-Talk Consulting and Software Engineering
Homepage: http://economy-x-talk.com
Twitter: http://twitter.com/xtalkprogrammer
KvK: 50277553

Become our partner in sales http://qery.us/16r Start selling Color Converter today. 20% commission!

On 25 okt 2011, at 21:27, John Patten wrote:

> Hi All…
> 
> Is it possible to export data from SQLite database, save it as a file, and then import it back into the same database?
> 
> I'm looking for a way to allow users of a LC project to save out their data in the SQLite database and then sneaker-net it on another machine using the same LC application and import into that app's SQLite database. 
> 
> Is there some SQLite statement that creates a query that I then can have LC save out as a file, and then do the reverse, and import it and run the query on the second machine?
> 
> Thank you!
> 
> John Patten
> SUSD