Results 1 to 4 of 4
  1. #1
    rgrstvr is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2010
    Posts
    25

    excel file imported into access shows up with more rows than the source


    the access file has a lot of rows which do not show on the excel file. the added files in access either have a space before their names, an * before their names, or no name at all. i would attach the new access file but it does not show up on my windows 7 list of files on my computer. it only shows up as a new file on my access program.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,930
    Can you provide the original Excel file?

    If you are importing into Access, why are there 'new' files? Why is the file hidden? Can change Windows Explorer to display hidden files. Here is one way http://windows.microsoft.com/en-us/w...iles=windows-7
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    rgrstvr is offline Novice
    Windows XP Access 2007
    Join Date
    Jan 2010
    Posts
    25
    unfortunately i cannot remember how to attach or refer to a file.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,930
    Forum attachment manager is below the Advanced Post Editor window. Click Go Advanced below the standard post editor.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Importing Excel File - Getting 7 extra blank rows each import
    By eking002 in forum Import/Export Data
    Replies: 4
    Last Post: 06-13-2013, 09:15 AM
  2. Replies: 2
    Last Post: 11-14-2012, 08:32 AM
  3. Replies: 5
    Last Post: 03-01-2012, 01:11 PM
  4. Excel rows sorted when imported to Access
    By gwn in forum Import/Export Data
    Replies: 1
    Last Post: 06-15-2011, 08:34 AM
  5. Linking Access Table with already imported External Data (Excel)
    By izzarshah in forum Import/Export Data
    Replies: 1
    Last Post: 07-29-2010, 09:40 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