| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
SQL Database
Hi all! Is there a way that you can access a SQL
Database using VBA in Excel? If so, how would I make that connection? Thanks in advance and Happy Holidays! Julie |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
SQL Database
Yes, place the following code ActiveSheet.QueryTables.Add
double click on QueryTables and press F1 for help. You'll find all answers and examples here to complete your task. regards KM -----Original Message----- Hi all! Is there a way that you can access a SQL Database using VBA in Excel? If so, how would I make that connection? Thanks in advance and Happy Holidays! Julie . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update Excel Database via Access Main Database with a script | New Users to Excel | |||
| Convert Excel database to dBASE database? | Excel Discussion (Misc queries) | |||
| database query not showing foxpro database How I import data | New Users to Excel | |||
| How to make reference to database and if true copy from database? | Excel Discussion (Misc queries) | |||
| Moved database, how do I change link to the database in excel | Excel Discussion (Misc queries) | |||
Linear Mode
