vba courses london - Extracting Data from Database

The UK's most regular instructor-led training courses.
Training information: vba courses london · Excel london

Resolved · Low Priority · Version Standard

Extracting Data from Database

Darren has attended:
Excel VBA course
Excel VBA course

by - delegate Darren [1 post] (2007 Apr 25 Wed, 16:28) Reply

How do I extract data from an Oracle Database and import into excel via a macro?

Thanks

RE: Extracting Data from Database

by - trainer David gold contributer [428 posts] (2007 Apr 30 Mon, 11:28) Reply

Hi Darren

This can be a very complex task. I would suggest maybe looking into an add-in for excel, that handles all of this for you.

The link below will take you to a site that contains a number of these products.
http://www.vicman.net/lib/spreadsheet.htm

Hope this helps
David

· Company Roles in Visual Basic Training
· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?

Vba tip:

Count the Rows and Columns in a Selection

If you need to count the number of rows or columns in a worksheet use the following code:

Selection.Rows.Count - Returns the number of rows in the selection

Selection.Columns.Count - Returns the number of columns in the selection

Selection.CurrentRegion.Rows.Count - Returns the number of rows in the current region of the selection

View all VBA hints and tips