Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Jan 2001
    Location
    PA
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    connecting to an .xls file

    [img]/w3timages/icons/frown.gif[/img]I need to have a table lookup info from an .xls file. I used the database connection wizard, and told it to look for my .xls file. The wizard successfully found the file, and created the connection. But the results returned are the row headings, not the data itself. I attempted to use different filter rules, and tried no filters at all. The same thing happens no matter how I try it. Only row headings are displayed.[img]/w3timages/icons/frown.gif[/img][img]/w3timages/icons/mad.gif[/img][img]/w3timages/icons/crazy.gif[/img]

  2. #2
    Platinum Lounger
    Join Date
    Jan 2001
    Location
    Roanoke area, Virginia, USA
    Posts
    3,729
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: connecting to an .xls file

    hmmm.... are you using rows or columns for your data layout in excel? when you set up the connection wizard, did the correct headings appear?

  3. #3
    Star Lounger
    Join Date
    Jan 2001
    Location
    PA
    Posts
    61
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: connecting to an .xls file

    I am using rows, with the headings at the top. I also have named ranges set up, because someone told me I had to have that done. And, yes, the correct headings showed up.

Posting Permissions

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