Asked By
Jody Akerly
80 points
N/A
Posted on - 11/28/2012
Where do I find and how do I implement a free SQL query editor for excel to configure the integration in such a way that the data being transferred are appropriately split before allocation of cells on the corresponding table?
Implementing free SQL query editor for excel for string splitting
Hi,
I would suggest using the QweryBuilder Express which is a free SQL Editor and SQL Query Tool that designed to work with SQL Server, Sybase ASE, Oracle and SQL and anywhere else.
In addition to these DMBS's, generic ODBC data sources are also supported.
I hope this helped.
Regards,
Peter franklin
Implementing free SQL query editor for excel for string splitting
Hello Jody Akerly ,
Hope that my message finds you well.
You can use “FlySpeed SQL Query”, it is for any database query not only excel. It is very simple and gives you the results fast and you can use it with most popular database queries.
You can find it in the following URL:
https://www.activedbsoft.com/overview-querytool.html
Also you can use “Excel tool SQL Query” version 10.6.28, it is software (add-in) for excel, allow you to build/have/create SQL query that is using for excel.
It will save a lot of time/effort and you can find it free.
To see more details about this use the following URL:
http://www.freenew.net/windows/excel-tool-sql-query-10628/49652.htm
Hope this solution will help.
Kind regards,