sql using access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I usually work with FoxPro using SQL.
Now I have to use Access to make some queries.
Could any of you tell me if I need to install some libraries to use group
by, etc.
What do I need to do to create my query and execute it? From where?

Thanks,
Sandra
 
Sandra said:
I usually work with FoxPro using SQL.
Now I have to use Access to make some queries.
Could any of you tell me if I need to install some libraries to use group
by, etc.
What do I need to do to create my query and execute it? From where?
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

It's not clear whether you are using the Access interface or just
accessing an .mdb data file using FoxPro. You do not need any special
libraries just for the GROUP BY clause. You have to have the JET
libraries and the DAO or ADO libraries.

You can create the query in a string and execute it using DAO or ADO.
Does FoxPro have these capabilities?

Can FoxPro use Automation? If so, you can open an instance of Access &
run an already created & stored query.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQnfUloechKqOuFEgEQIQbQCg2WFjVeal69RsShFo5RAlzmzKdMgAn0mG
J3fa/lCF9zC/pouvZsUkjIi6
=h1ls
-----END PGP SIGNATURE-----
 
Back
Top