SQL Center

With the SQL-Center you can import, export and manage many kinds of different data sources, according to the table below.

With this software you can get virtually any kind of data, from any kind of source, manipulate it as your desire and export the result as a lot of output formats.

Format	Import	Export
HTML
Clipboard
XLS
POP3
TXT / CSV
BDE
OFX (Open Financial Exchange);
OFC
RSS		-
QIF (Quicken Interchange Format)
Microsoft Money		-
AddressBook (Windows / Outlook Express)		-
Network Computer and Shared Devices		-
File Search		-
Internet Search		-
Sound Card (Speak)	-

Formats suported by the SQL Center

Command	Description
select * from "teste.txt" select * from "teste.htm" select * from "teste.xls;Plan1;B2..D5" select * from "http://www.delphi.nack.com.br/teste.html" select * from ClipBoard select * from c:\ select * from c:\ /s select * from c:\.mp3 /s select from DBDemos.* select * from DBDemos.Customer select * from xxx@yyy.com.br;pop3.yyy.com.br:110 select * from network select * from internet where "Delphi Nack" select * from AdressBook
select * from phones where "Farmacia"	Work only with Brazilian phone numbers
select * from a teste.txt, b cid.txt, c uf.txt join a.CdCid = b.Codigo and a.UF = c.UF	Select data from many different sources and join it in one result set
select * from "teste.txt" order by Nome select * from "teste.txt" order by idade select * from "teste.txt" order by salario select * from "teste.txt" where idade > 20
order by Nome order by idade order by salario	Order the data loaded into the memory by the specified column
where idade > 25 where null	Filter the loaded data without reloading the source
export to c:\abc.txt export to c:\abc.htm export to c:\abc.xml export to clipboard export to DBDemos.Customer export to speaker	Export the data to the specified output format
explode Valor by Data into month explode Valor by Data into bimester explode Valor by Data into trimester explode Valor by Data into quarter explode Valor by Data into semester explode Valor by Data into year
Add Column i integer
Drop Name
ren Valor Value

Examples of some useful commands

The SQL Center is FREE and you can download it here.
(Version 2.8)

If you like to see another formats implemented in the SQL-Center, please send us your suggestion about it.