| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Creating a front end application to sql data set
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Creating a front end application to sql data set
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Creating a Chart in a C# Application... | Charts and Charting in Excel | |||
| creating Excel Application Object in C#? | Excel Programming | |||
| Creating new Excel Application problem | Excel Programming | |||
| Creating An Application Event Handler | Excel Programming | |||
| Creating an private Excel.Application | Excel Programming | |||
Linear Mode
