Results 1 to 6 of 6
  1. #1
    bvtterflygirl is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2011
    Posts
    3

    Importing an Excel file

    Everytime I import an Excel file into Access it contains many fields with no data. I tried selecting the pertinent data in the spreadsheet and naming the range (or defining the range) but that did not change how the import wizard imported the file.

    Any suggestions? I would really like to be able to use this but those extra lines are killing me.



    Many Thanks,
    bvtterflygirl

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    you're using the import wizard? are those fields there in your xls too? If they are, then what's happening is normal. For instance, if you have columns A-J in your excel file, column J has data somewhere in it, but columns C,D and E have no data in them, an import will probably give you C,D and E, which of course will be blank.

  3. #3
    bvtterflygirl is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2011
    Posts
    3
    I have columns A thru I, rows 1 thru 8779, I have named that range, however my problem is when I do the import, it is importing columns A thru I, rows 1 thru 17753. There is absolutely no data below row 8779.

  4. #4
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    highlight rows 8780 and down. That'll be what? 57,000 rows or something? highlight all of them and DELETE them via the right click menu. don't push the delete key. dont' delete the data, actually delete the ROWS. see if that helps.

  5. #5
    bvtterflygirl is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Feb 2011
    Posts
    3
    Thanks for that suggestion, it worked. I also tried a different approach on a second file of the same nature with the same problem. I cleared the contents on a small section and achieved the same result, only the records I wanted were there.

    Thanks very much!!

  6. #6
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    Quote Originally Posted by bvtterflygirl View Post
    Thanks for that suggestion, it worked. I also tried a different approach on a second file of the same nature with the same problem. I cleared the contents on a small section and achieved the same result, only the records I wanted were there.

    Thanks very much!!
    marked as solved.

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

Similar Threads

  1. Replies: 0
    Last Post: 09-18-2009, 07:33 AM
  2. Importing Txt file via Vb
    By jquickuk in forum Import/Export Data
    Replies: 1
    Last Post: 04-01-2009, 08:27 AM
  3. Importing file into Access
    By jquickuk in forum Import/Export Data
    Replies: 1
    Last Post: 03-23-2009, 09:18 PM
  4. Issues with dating when importing excel file
    By Lainie in forum Import/Export Data
    Replies: 0
    Last Post: 01-22-2009, 10:50 AM
  5. Importing from Excel
    By joer in forum Forms
    Replies: 0
    Last Post: 03-14-2007, 02:01 PM

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