98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - Extracting Data from Database
vba courses london - Extracting Data from Database
Resolved · Low Priority · Version Standard
Wed 25 Apr 2007, 16:28Delegate 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:28Trainer 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 information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
VBA tip:Use VbNullString instead ofWhen needing to default a String variable back to it's default of "" use vbNullString as in the following example: |
