Creating a front end application to sql data set

  • Thread starter Thread starter AD108
  • Start date Start date
A

AD108

I want to start learning how to access an sql data base (using excel as the
front end, if that is correct terminology. Where is a good place to start.
I have a little experience with VBA, and I would like to start learning the
sql language.
 
MS Access Queries can be switched to SQL View: this will allow you to type
and execute SQL statements. It might be a good place to start.

If your database is SQL Server, you can use Query Analyser; for Oracle use
SQL*PLUS. These are already written SQL front ends.

It is fairly easy to write your own SQL front end: however, you said that
you do not know VBA and that makes it difficult.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel as front end and SQL Server as back end 0
sql vba applications 1
Who do you read an ini file with Excel VBA? 3
Open a word mail-merge document from Excel VBA 1
SQL not importing records from ACCDB 2
Excel front-end and Access back-end? 9
Excel Front End for SQL Server 2
Do you need MS Access to query on an Access table? 1

Back
Top