+ Reply to Thread
Results 1 to 6 of 6
  1. #1
    Pump you sucker! Pump! Chuckiechan's Avatar
    Join Date
    Oct 2001
    Location
    Sacramento, El Norte
    Posts
    15,312

    Excel List won't convert to Access

     
    When I try to take a list in (MS Office 2000) Excel and convert it to Access I get the error message:

    "The Microsoft Jet database engine could not find the object '<pricepag$R1C1:R89C9>'. Make sure the object exists and that you spell its name and the path name correctly."

    I have the DB and Worksheet in the same folder. I get a yellow screen saying is was accomplished and where the file is , but the file is empty - as in no import due to this error.

    Ideas?

    Thanks in advance
    Obama: The rich have the Federal Reserve and the poor have Harry Reid... LOL. Life really is unfair!

  2. #2
    addicted DVNT1's Avatar
    Join Date
    Oct 2001
    Location
    Ohio
    Posts
    6,103
    Sorry so late, did you get worked out or is it still a problem?

  3. #3
    Junior Member
    Join Date
    Mar 2003
    Posts
    1
    Did you ever figure this out. I am having the same problem. BTW, do you happen to have a Novell network? I'm trying to find a common denominator on this.

  4. #4
    shahani
    Guest
    Only epidemic can solve this. He knows excel perty well.

  5. #5
    Member Marvinator's Avatar
    Join Date
    Mar 2003
    Posts
    300
    If you are exporting a single sheet, this reference is on another worksheet. You need to export all the information as one worksheet, or Excel won't be able to "find" the references.
    now THIS is interesting....

  6. #6
    MR Meek and Mild Epidemic's Avatar
    Join Date
    Mar 2002
    Location
    almost Virginia
    Posts
    10,692
    Blog Entries
    2
    I know excel perty good.

    Access kicks my arse every time.

    I usually cheat and import from text CSV or dbf or the likes.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may post new threads
  • You may post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Recommended Sites: ResellerRatings Store Reviews