Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: database

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Location
    Arkansas
    Posts
    358
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    New vb user. I am trying to look up a external dbase with 9 different fields and import into my Excel spreadsheet. Is there any visual basic script or comand that will do that ? Thx Dan

  2. #2
    MrExcel MVP lenze's Avatar
    Join Date
    Feb 2002
    Location
    Helena, MT
    Posts
    13,690
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    You could use Vb to do this, but why not use MS Query. It's an add-in that comes with Excel(Tools Add-ins). You may also have to activate the driver for your database.

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Location
    Arkansas
    Posts
    358
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    At the moment I am uning queeries. The problem is I am conecting to 7 different dbases and dont nead to use but 1 or two at a time. Was hoping to speed up the sheet. Thx Dan

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    =ActiveCell.Address
    Posts
    478
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I've found the xlodbc addin pretty handy as well. I use it in a daily macro that processes a bunch of Excel files and then loads them into a mysql database on a Linux box (Microsoft would be proud!)

    MS Knowledgebase article is quite helpful in getting started.

    http://support.microsoft.com/default...;en-us;Q124218

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •