Results 1 to 4 of 4
  1. #1
    captgnvr is offline Advanced Beginner
    Windows 2K Access 97
    Join Date
    Sep 2009
    Posts
    44

    no option to import xls file or option all files


    Dear All

    access 97. trying to import from excel97. but no option in access to import xls file or the option to show 'all files'. pls help

  2. #2
    SoftwareMatters is offline Access VBA Developers
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    274
    The import window should have a drop-down called "Files of Type" - you can choose Excel files from this.

  3. #3
    captgnvr is offline Advanced Beginner
    Windows 2K Access 97
    Join Date
    Sep 2009
    Posts
    44
    Thank you for the help but what I am trying to inform is that there is no option in the drop down list to select excel file or the option "all files".

    I tried all that changing the file names and reregistering. So pls help.

  4. #4
    SoftwareMatters is offline Access VBA Developers
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    274
    Can you send a screendump (Ctrl+PrintScreen) of what happens once you've clicked import

Please reply to this thread with any new information or opinions.

Similar Threads

  1. VB code for sending email through Option Group?
    By getdpt in forum Programming
    Replies: 0
    Last Post: 08-23-2009, 03:59 PM
  2. option group in form
    By mawa4492 in forum Forms
    Replies: 1
    Last Post: 08-05-2009, 02:49 PM
  3. VBA Code in Access w/ option buttons
    By WebKiid in forum Access
    Replies: 1
    Last Post: 07-16-2009, 12:20 PM
  4. Option Group broken out
    By dcecil in forum Reports
    Replies: 3
    Last Post: 04-21-2009, 10:30 AM
  5. Browse Option
    By emilylu3 in forum Access
    Replies: 1
    Last Post: 01-10-2006, 09:46 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums