MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Problem with Length of the worksheet name

  Asked By: Jody    Date: Oct 12    Category: MS Office    Views: 1737

I am using Microsoft Jet Database Engine 4.0 for uploading
data from Excel sheet to database. When the name of the sheet is greater than 30
then for the statement
"select * from [abcdefghijklmnopqrstuvwxyzabcde$D16:D16]", it is giving
me an error

The Microsoft Jet database engine could not find the object
'abcdefghijklmnopqrstuvwxyzabcde$D16:D16'. Make sure the object exists and that
you spell its name and the path name correctly.

Can anyone get me the solution earliest by today evening.



No Answers Found. Be the First, To Post Answer.

Didn't find what you were looking for? Find more on Problem with Length of the worksheet name Or get search suggestion and latest updates.