Export Library to CSV or Excel or any other Database

Everything, that fits not well into other forums - Questions, Talk, Beta-Versions ...
[phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1266: count(): Parameter must be an array or an object that implements Countable
munsing
Posts: 42
Joined: 24. Mar 11, 22:38
[phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1266: count(): Parameter must be an array or an object that implements Countable

Export Library to CSV or Excel or any other Database

Postby munsing » 10. Apr 11, 06:17


SilverEagle
Posts: 713
Joined: 30. Sep 08, 14:00
Location: Netherlands
[phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1266: count(): Parameter must be an array or an object that implements Countable

Re: Export Library to CSV or Excel or any other Database

Postby SilverEagle » 11. Apr 11, 08:27

Hi Munsing,

munsing wrote:
> I'm trying to put my database online for guests to be able to search via our webpage. It would be great if I could export my database to another format other than SQLite.

Best answer: Don't!

Just use ODBC access to your live SJ tables. No doubt you can use ODBC from whatever weblanguage you are using. See for a driver which I know works with the SJ database. No idea if you are familiar with ODBC, if you need a hand setting it up just ask.

For the original question: naturally you could use the same ODBC access to open the database in Excel and export in whatever format you'd want.

(And now I only hope you were going to run this on Windows and not on a Mac...)

SilverEagle


[phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1266: count(): Parameter must be an array or an object that implements Countable
[phpBB Debug] PHP Warning: in file [ROOT]/vendor/twig/twig/lib/Twig/Extension/Core.php on line 1266: count(): Parameter must be an array or an object that implements Countable

Return to “Main Forum”