What
is an Excel Add-In?
Will
XL-DBQuery allow me
to connect and query
data from any data
source?
I
still use Excel 97.
Can I use XL-DBQuery
with this version of
Excel?
I
want to use
XL-DBQuery to merge
data from different
sources, is this
possible?
I
want to share my
Data Source Library
file with
colleagues’, is this
possible?
I
have purchased a
Professional License
of XL-DBQuery which
allows me to connect
and query external
data. I wish to
allow users with the
Standard License to
query the external
data but I don’t
want to allow them
to create a
connection to the
external data
themselves. Is this
possible?
Once
I have exported my
data to Excel, will
I need to re-run the
query in XL-DBQuery
each time I want an
update of the data?
I
have purchased a
Standard License of
XL-DBQuery. Can I
upgrade to the
Professional
License?
What
do I need to be able
to connect to my
QuickBooks Database?
What
is an Excel Add-In?
Answer: An
Excel Add-In is
designed to extend
and enhance Excel’s
own in built
features and
functionality, by
providing third
party software
vendors a means of
embedding their own
software directly
into Excels existing
toolbars and menus.
To a user, the
software appears to
be an intrinsic part
of Excel.
Return to top
Will
XL-DBQuery allow me
to connect and query
data from any data
source?
Answer: Yes,
you can can connect
and query data from
virtually any data
source, including
CSV text files,
Access, SQL Server,
Oracle and off
course Excel itself.
However the data
source MUST
adhere to the SQL
Ansi-92 standard to
comply with the
method that
XL-DBQuery uses to
create table joins,
i.e. (Inner Join,
Outer Join).
Return to top
I
still use Excel 97.
Can I use XL-DBQuery
with this version of
Excel?
Answer:
Unfortunately,
XL-DBQuery isn’t
compatible with
Excel 97. However it
can be used with all
versions of Excel
from 2000 on,
including Excel
2007.
Return to top
I
want to use
XL-DBQuery to merge
data from different
sources, is this
possible?
Answer: Yes,
this is possible by
firstly exporting
the data from the
different data
sources into excel
and creating a new
‘MS Office Data
Source’ that uses
the active workbook
as a data source.
You can then join
the two sheets based
on the common key
and export the
results to another
sheet. For a further
detailed demo of
this solution,
please refer to the
flash demo entitled
‘Merging data from
different data
sources’.
Return to top
I
want to share my
Data Source Library
file with
colleagues’, is this
possible?
Answer: Yes,
this is possible.
Just save your Data
Source Library file
to a location that
your colleagues can
gain access to it
and ask your
colleagues to create
a new query and
browse and open the
saved Data Source
Library file.
Return to top
I
have purchased a
Professional License
of XL-DBQuery which
allows me to connect
and query external
data. I wish to
allow users with the
Standard License to
query the external
data but I don’t
want to allow them
to create a
connection to the
external data
themselves. Is this
possible?
Answer: Yes,
this is possible.
Either open the
Standard user’s Data
Source Library file
and create a new
‘External Data
Source’ and save it
to their file or
create a new Data
Source Library file
including the
external data source
and save it to a
location where the
Standard user can
open it. The
Standard user can
now query the
external data source
and edit the tables
and views that they
wish to query.
Return to top
Once
I have exported my
data to Excel, will
I need to re-run the
query in XL-DBQuery
each time I want an
update of the data?
Answer: No,
If your query
criteria remains
unchanged, you can
simply select a cell
where your Excel
data or pivot table
resides and right
click your mouse and
select ‘Refresh
Data’ from the
pop-up menu, this
will trigger Excel
to re-run your query
and refresh your
results. You can
also edit the query
from Excel by
selecting the ‘Edit’
option from the same
pop-up menu. For a
further detailed
demo of this
functionality,
please refer to the
flash demo entitled
‘Refreshing queries
from Excel’.
Return to top
I
have purchased a
Standard License of
XL-DBQuery. Can I
upgrade to the
Professional
License?
Answer: Yes,
this is possible.
Please refer to our
purchase page for
further details on
how you can upgrade.
Return to top
What do I need to be
able to connect to
my QuickBooks
Database?
Answer: QuickBooks
users
wishing to
query and
export their
QuickBooks
data using
XL-DBQuery,
will need
ensure that
they have
the
QuickBooks
ODBC Driver
(QODBC)
installed on
their
machine.
QuickBooks
Enterprise
users will
already have
the Driver
installed.
Return to top
Frequently Asked
Questions