Results 1 to 7 of 7
  1. #1
    Join Date
    Oct 2005
    Posts
    6

    Unanswered: importing problem

    I am trying to import / link a excel spreadsheet which contains approx. 37000 records. After I do this I can only view approx, 16000 of these. I even tried deleting the spreadsheet down to approx. 27000 records and get the same result???

    Any thoughts on what maybe causing this?
    I am using Access 97

  2. #2
    Join Date
    May 2004
    Location
    New York State
    Posts
    1,178
    Do you have the same problem when you link? The spreadsheet may be so large that when you import it, it makes your database exceed the 1 gig limit, which is the limit for A97. (A2003 goes to 2 gigs; I don't know about A2000.) If that's the case you shouldn't have that problem when you link. If you do, maybe there's a different problem.

    Try the following: delete the spreadsheet from your Access DB and compact your database (Tools--> Database Utilities--> Compact and Repair Database). Now try re-importing. Do you still have the problem?

    HTH

    Sam

  3. #3
    Join Date
    Oct 2005
    Posts
    6

    didn't work

    tried that buy I get the same result- totally confused over this
    I done this in the past so many times and never had this problem before!!

  4. #4
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    What exactly are you doing when you say "import/link"? Are you using a wizard, ado/dao/etc dataset, linked table, standard import or something else entirely?
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  5. #5
    Join Date
    Feb 2004
    Location
    Chicago, IL
    Posts
    1,312
    I would look at the 16001st record. Is there any weird data in that record? What happens if you make a copy of the spreadsheet, delete that row and try to re-import?

    Another thought, copy the spreadsheet, save it as a CSV file (File/Save As), then change the extension to TXT and open it in Notepad or Wordpad. Any data corruption/weirdness might be easier to spot this way. Also turn off word wrap in Notepad.

  6. #6
    Join Date
    Oct 2003
    Location
    Chicago, IL
    Posts
    154

    2

    Try compact/repair database, try again?

  7. #7
    Join Date
    Oct 2005
    Posts
    6

    thanks all

    finally had enough of this and upgraded to 2000. nothing seemed to work
    after installing access 2000 I was able to import the data first time.

Posting Permissions

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