Microsoft® Excel® based database addin

 
+ Reply to Thread
Results 1 to 6 of 6
  1. 06-03-2008 05:44 AM #1
    admin's Avatar
    admin
    admin is offline Administrator
    Join Date
    Apr 2008
    Location
    Dublin, NYC
    Posts
    333
    Blog Entries
    1

    Default ideas for enhancements

    Hi Everyone,

    I am trying to figure out what would be good to work on for the next release so posting up.
    am thinking that some of the items below will be good.
    - Add a button to halt execution of a query
    - Format/beautify the SQL statements in the main form text box.
    - add in a button to generate the ado/vb code equivalent for a SQL statement.

    There were several other suggestions made and I need to go back and find them but this is a basic list to look at.

    It would be good to know what people think would be good to add.

    Thanks and see you, Al
    SQL Drill Support
    www.sqldrill.com
    Reply With Quote Reply With Quote  
  2. 06-04-2008 03:45 AM #2
    admin's Avatar
    admin
    admin is offline Administrator
    Join Date
    Apr 2008
    Location
    Dublin, NYC
    Posts
    333
    Blog Entries
    1

    Default Re:ideas for enhancements

    Hi All

    Was thinking tonight that another thing that might be worth doing would be to enable the add-in to work in other Microsoft office applications - Word, Outlook, Frontage, Access.

    The embed query to worksheet functionality would have to be disbled but apart from that, the other functionalties should work fine. Would have to use the different object types for the pasting of the data (use Table in Word instead of Range etc.) but apart from there should not be too many changes.

    Enabling the add-in to work within Microsoft Access might seem like a crazy idea at this point but I think that with later versions it could be a useful add-in to have.

    Not sure if that is a good idea.. If anyone has an idea on that please post up.
    Thanks, Al
    SQL Drill Support
    www.sqldrill.com
    Reply With Quote Reply With Quote  
  3. 06-04-2008 08:58 AM #3
    roland
    roland is offline Junior Member
    Join Date
    Jun 2008
    Posts
    27

    Default Re:ideas for enhancements

    Hi Al!

    I think that\'s a great idea, even including it into Access, as the improvement over the standard query wizard is tremendous.

    -regards,
    Roland
    Reply With Quote Reply With Quote  
  4. 06-04-2008 02:15 PM #4
    admin's Avatar
    admin
    admin is offline Administrator
    Join Date
    Apr 2008
    Location
    Dublin, NYC
    Posts
    333
    Blog Entries
    1

    Default Re:ideas for enhancements

    Hi Roland

    Thanks very much and for signing up site.. I see you posted up a good few messages.. Thanks a million for that. Great to get all the feedback.
    Was up late last night and just got up. Have to rush out now to go into town.

    I think you are right that it will be good to have in Access. So, say your are in Access but want to link to MYSQL or some other provider. If there is a way to embed the query into Access it will be great.

    Very sorry, have to rush. Late already. Back later on, thanks, al
    SQL Drill Support
    www.sqldrill.com
    Reply With Quote Reply With Quote  
  5. 02-03-2009 09:12 AM #5
    hercules
    hercules is offline Junior Member
    Join Date
    Feb 2009
    Posts
    3

    Default Re:ideas for enhancements

    Hi,

    Is it possible to change a queryy afther it has been embedded in excel to reopen it and change it with sqlexcel?

    Thx,
    Reply With Quote Reply With Quote  
  6. 02-03-2009 11:23 AM #6
    admin's Avatar
    admin
    admin is offline Administrator
    Join Date
    Apr 2008
    Location
    Dublin, NYC
    Posts
    333
    Blog Entries
    1

    Default Re:ideas for enhancements

    Hi !

    Thanks for that. It will be cool if this is added in. I think it came up sometime ago too.
    One part of it is implemented already so there is a function to pass in a sql string and the main form will load with the query in it. But this would have to be extended out to take input from a cell and then get the embedded query from the cell etc..

    Thanks for bringing this up again. Will look into it again. Not sure if it will get into next release though as already getting into some testing of it. But will see.

    Thanks again and have a very nice day

    Al
    SQL Drill Support
    www.sqldrill.com
    Reply With Quote Reply With Quote  
« Previous Thread | Next Thread »

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules