Hi,
I am sorry if my question may look like a bit off-topic but,
are there excel tools or utils that I can try some SQL commans or codes?
Regards
Hi,
I am sorry if my question may look like a bit off-topic but,
are there excel tools or utils that I can try some SQL commans or codes?
Regards
you will find everything posted on the access.programming newsgroup
"J_J" wrote:
> Hi,
> I am sorry if my question may look like a bit off-topic but,
> are there excel tools or utils that I can try some SQL commans or codes?
> Regards
>
>
>
Hi JJ
If you have Access you will also have Northwind “the sample DB.”
You can run one of the sample queries and then choose
Menu: View: SQL: SQL View
This will show the SQL query statement.
I have seen numerous recommendations from people that recommend
things like this if using Access as the back end, development and test
your query in Access and then copy and paste the SQL statement into
your code. However, even if you do not intend to use Access an SQL
statement is an SQL statement wherever you learn it or use it.
Good Luck
TK
>
> "J_J" wrote:
>
> > Hi,
> > I am sorry if my question may look like a bit off-topic but,
> > are there excel tools or utils that I can try some SQL commans or codes?
> > Regards
> >
> >
> >
Yes, there is a query builder available in Excel. From the menu choose
Data > Import External Data > New Database Query.
It will walk you through a wizard for selecting the data source and the
tables, then present you with a QBE grid (QBE = query by example).
There's an 'SQL' toolbar button that you can click to enter the SQL
manually.
You can also play around with SQL by writing data access code in VBA.
The help files are pretty good for showing some basic stuff.
If you don't have a database to use (e.g. Access or SQL Server), you
can just use Excel as a data source. In another Excel file, create a
grid of data with row headings. Then define a name for the range. When
you use the Import External data wizard I mentioned above, select the
Excel file as your data source.
HTH,
Nick Hebb
BreezeTree Software
http://www.breezetree.com
Thank you all...NIck, TK and Vacation's Over
You are most helpful.
J_J
"Nick Hebb" <n.hebb@comcast.net> wrote in message
news:1127612303.979397.223520@g47g2000cwa.googlegroups.com...
> Yes, there is a query builder available in Excel. From the menu choose
> Data > Import External Data > New Database Query.
>
> It will walk you through a wizard for selecting the data source and the
> tables, then present you with a QBE grid (QBE = query by example).
> There's an 'SQL' toolbar button that you can click to enter the SQL
> manually.
>
> You can also play around with SQL by writing data access code in VBA.
> The help files are pretty good for showing some basic stuff.
>
> If you don't have a database to use (e.g. Access or SQL Server), you
> can just use Excel as a data source. In another Excel file, create a
> grid of data with row headings. Then define a name for the range. When
> you use the Import External data wizard I mentioned above, select the
> Excel file as your data source.
>
> HTH,
>
> Nick Hebb
> BreezeTree Software
> http://www.breezetree.com
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks