Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Weird import to Access

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    4
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    I have 300 lines of data in an Excel workbook, but when I copy them over to Access it says I have over 700???

    Does anyone have any idea why this could be?

  2. #2
    New Member
    Join Date
    Feb 2002
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Do you have any hidden rows that may be getting copied over?

  3. #3
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Test:

    Hit ctrl-home to get to cell A1.
    Hit Shift+Ctrl-End to get to the last used cell.

    If the selection is beyond your data, then Excel thinks there's stuff in those cells, and so will Access.

    To clean it up, see the 4th item under:

    http://www.thewordexpert.com/excel.h...monExcelIssues
    ~Anne Troy

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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