Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Baltimore, MD, Maryland, USA
    Thanked 0 Times in 0 Posts

    USing DAO to query XLS Table (Office 97 Win98)

    Hi Fellow Loungers and Happy New Year to you all:
    I have a simple question today. How do I set up some columns and rows in an XL worksheet to be a data table so I can connect to it using DAO? When I use my ODBC connection from another XL file and specify the target file, I get the message that there is no data table in that file.
    Thanks <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

  2. #2
    Bronze Lounger
    Join Date
    Jun 2001
    New York, New York, Lebanon
    Thanked 1 Time in 1 Post

    Re: USing DAO to query XLS Table (Office 97 Win98)


    Happy New year to you too.

    If you are getting info from Excel to Excel why not use the simpler methods than DAO?

    But I guess if you would give the range a name say Database, then Excel will know what you want. I did run through something similar and all I had to do is give it a name.

    Now as to the header row, I can't remember if it should be included or not, try both cases.

    <img src=/S/compute.gif border=0 alt=compute width=40 height=20> in the <img src=/S/bagged.gif border=0 alt=bagged width=22 height=22>

Posting Permissions

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