Implementing free SQL query editor for excel for string splitting

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?

• Status: Open
• Question Views: 807
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MS SQL Server

Best Answer by May Jratr

Go To Solution

Answered By Peter franklin 10 points N/A #156658

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

About Peter franklin

Questions
0

Answers
102

Best Answers
35

• Vote Up 0 Vote Down

• Posted on - 12/15/2012
• Question Category: MS SQL Server

Best Answer

Best Answer

Answered By May Jratr 0 points N/A #156659

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,

About May Jratr

Questions
2

Answers
100

Best Answers
31

• Vote Up 0 Vote Down

• Posted on - 12/15/2012
• Question Category: MS SQL Server