vba courses london - Extracting Data from Database

Resolved · Low Priority · Version Standard

Wed 25 Apr 2007, 16:28 Delegate Darren said...

Darren has attended:
Excel VBA Intro Intermediate course
Excel VBA Intro Intermediate course

Extracting Data from Database

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

Thanks

Mon 30 Apr 2007, 11:28 Trainer David said...

RE: Extracting Data from Database

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

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

VBA tip:

Use VbNullString instead of

When needing to default a String variable back to it's default of "" use vbNullString as in the following example:

Sub ClearText()

Dim strEmpName As String

strEmpName = "John Smith"
MsgBox strEmpName

strEmpName = vbNullString
MsgBox strEmpName

End Sub

View all VBA hints and tips