[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 299
  • Last Modified:

Microsoft jet database enginer error

Hi

I was importing data from an excel sheet , then this error occured.

The microsoft jet databse enginer could not find the object pid_import......please see if the name or spelling is correct...
Any clues
0
Osloiite
Asked:
Osloiite
1 Solution
 
puppydogbuddyCommented:
You did not identify what the object pid_import refers to in your worksheet...is it a column (field), a named range, or ?

This link below is an excellent reference for you to look at because it walks you through different scenarios and listing the error message received based on the scenario.  The final cause for the error in the thread below is that the worksheet was on a local machine and had to be moved to the server in order for the SQL query to find it.

    http://www.tek-tips.com/viewthread.cfm?qid=1205358&page=9
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now