Geting database output in excel file

[nn92]

Dear all,

As a part of the project I am working on, I have to create an application which will access companys DataWareHouse (I was given username and password and web address) and under criterias I select export data in excel file.

As I am beginner with VBA, could you please tell me:
1) If this is possible to be done with VisualBasic
2) Recommend materials for start learning


I was advanced VBA user, but 4 years ago, so I would like to take a course from beginning.

I am looking forward for your ansvers!

thanks in advance

[westconn1]

I was advanced VBA user, but 4 years ago

that is not so long

If this is possible to be done with VisualBasic

i would think quite possible, you could possibly do a web query into a table

[Ecniv]

Or use ADO connection and a predefined query to grab results, with a VBA loop to drop into excel plus format etc... if required.

[TysonLPrice]

Have a look here:

http://vb.net-informations.com/excel..._tutorials.htm

[techgnome]

Please don't create duplicate posts. It splits the answers and creates more confusion than it solves.
Duplicate post: http://www.vbforums.com/showthread.p...-in-excel-file

Now you have responses there and here. Those in this thread may not know what was posted in the other, and the posters in the other don't know what's here. You're going to get different sets of answers that may end up conflicting with each other, and when you try to resolve it, it will create more confusion.

I've notified the mods, so the threads may end up getting merged.

-tg

[si_the_geek]

Welcome to VBForums

Duplicate threads merged - please post each question (or variation of it) only once. If you think you have posted in the wrong forum, click the "report" icon on the left of a post (or PM a moderator) to ask for it to be moved.