Welcome to Dream.In.Code
Become a VB Expert!

Join 149,571 VB Programmers for FREE! Get instant access to thousands of VB experts, tutorials, code snippets, and more! There are 1,661 people online right now. Registration is fast and FREE... Join Now!




excel database connection

 
Reply to this topicStart new topic

excel database connection

scalt
22 Nov, 2007 - 03:01 PM
Post #1

D.I.C Head
Group Icon

Joined: 22 Nov, 2007
Posts: 111



Thanked: 2 times
Dream Kudos: 25
My Contributions
Hi,
My issue is that I have very large (150 MB +) Excel files that I want to connect to as databases so I can use SQL statements to extract data out of them.

Can someone recommend a way to do this? I have tried an ADODB connection and am making some headway with that, but if there is someone out there who has more knowledge and real-world experience about this then any advice would be great.


Thanks
User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic
Time is now: 1/7/09 10:24PM

Be Social

Dream.In.Code RSS Feed Dream.In.Code LinkedIn Group Follow Us On Twitter

Live VB Help!

VB Tutorials

Reference Sheets

VB Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month