SQL ExcelSQL Excel

Freeware Excel Add-In - Simplify data retrieval from SQL Server, Oracle, Sybase, MySQL, DB2, Firebird and any other ODBC compliant database

SQL Excel Support
Welcome, Guest
Please Login or Register.    Lost Password?
Re:Table (1 viewing) (1) Guest
Please post here about SQL Excel useage within Excel. Excel / VBA type topics should go in there. Thanks.
Go to bottom Post Reply Favoured: 0
TOPIC: Re:Table
#289
Lord Excel (User)
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
Table 3 Months, 3 Weeks ago Karma: 0  
Hi Folks,
First of all,Excuse me for my not so good english
Second, Very thanks for this great tool. I think is a very job.

I have a big question!
The risult is possible to integrate automatically in a Table of Excel 2007?

Thanks a lot!
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#290
admin (Admin)
Admin
Posts: 175
graph
User Online Now Click here to see the profile of this user
Re:Table 3 Months, 3 Weeks ago Karma: 1  
Hi !
Hope all is great for you. Your english is fine by the way..

You should be able to do that. One way to do it would be to embed the query (use the "Embed" button on the main form) into an excel worksheet. Then you could use right click and "refresh" to reimport the data as needed. Or you could record a macro and attach it to a button or to a different event (file opening or something like that.)

I hope that is ok. Let me know if that is not what you want to do)
thanks and have a nice night, al
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#291
Lord Excel (User)
Fresh Boarder
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
Re:Table 3 Months, 3 Weeks ago Karma: 0  
many tanks for your reply.

This is npt what i want to do.
The Table in Excel 2007 are very useful. They permit automatic filling trough all the table.
I manage a very lot of Data.
I use always MSqwery. Now I've see SqlExcel and I Would Like use it.
When I try to convert in a table a "Embedded" data from SqlEsxcel a alert inform me that i'll miss the connection with external source.

Thanks a lot
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
Go to top Post Reply
Thanks for using the forum SQL Excel Freeware Add-inget the latest posts directly to your desktop

Google Translate

Copyright SQL Excel, 2007-2008 | valid xhtml? | valid CSS? |Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation