January 15th, 2003, 11:50 AM #1
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.
Thanks in advanceObama: The rich have the Federal Reserve and the poor have Harry Reid... LOL. Life really is unfair!
February 5th, 2003, 10:32 PM #2
Sorry so late, did you get worked out or is it still a problem?
March 28th, 2003, 04:27 PM #3
- Join Date
- Mar 2003
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.
March 28th, 2003, 04:29 PM #4shahaniGuest
Only epidemic can solve this. He knows excel perty well.
March 28th, 2003, 04:30 PM #5
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....
March 28th, 2003, 04:40 PM #6
- Join Date
- Mar 2002
- almost Virginia
- Blog Entries
I know excel perty good.
Access kicks my arse every time.
I usually cheat and import from text CSV or dbf or the likes.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)