SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Is it possible to set up Excel as a sql source for S.A.?

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
Is it possible to set up Excel as a sql source for S.A.?
Author Message
SqlExplorer



Joined: 18 Sep 2011
Posts: 103

Post Is it possible to set up Excel as a sql source for S.A.? Reply with quote
Hi,

I'm trying to add Excel in Db Options, but it's not in the DB Type list.

Is there a way to use Sql Assistant to run queries off of an Excel table?
Fri Jul 16, 2021 12:53 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7833

Post Reply with quote
Yet, I think you can do that, although I haven't specifically tested what I'm going to suggest. You can create an empty Microsoft Access database or use any existing and in Access you can link Excel files as external tables. And that you can connect to your Access database from SQL Assistant SQL Editor and query these tables pretty much like all other Access tables using using SQL dialect supported by Access.
Fri Jul 16, 2021 4:29 pm View user's profile Send private message
SqlExplorer



Joined: 18 Sep 2011
Posts: 103

Post Reply with quote
Thanks, SysOp. We might reload the data (from a tab-delimited file) into Sqlite, and not use Excel after all. We would make that the default connection in Sql Assistant, temporarily.


SysOp wrote:
Yet, I think you can do that, although I haven't specifically tested what I'm going to suggest. You can create an empty Microsoft Access database or use any existing and in Access you can link Excel files as external tables. And that you can connect to your Access database from SQL Assistant SQL Editor and query these tables pretty much like all other Access tables using using SQL dialect supported by Access.

Sat Jul 17, 2021 5:10 pm View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.