Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Accessing excel worksheet via ODBC...

Status
Not open for further replies.
romekf

romekf

Programmer
Oct 7, 2003
1
0
0
PL
Hi,
I have a problem witch accessing data from excel using ODBC driver. There were no problems with it, when I was using Win 98 and Office 2000. Now, I'm using WinXP and Office XP and the problems starts....
ODBC connection is OK, but I have an error:
[Microsoft][ODBC Excel Dirver]Microsoft JET cannot find the object "my_table_name".
Previously, (WIN 98) my table name was Excel worksheet name.
I don't have any idea why it's not working.

Thank you for any reply.
Best regards,
romekf
 
Status
Not open for further replies.

Similar threads

hacpro
  • Locked
  • Question
ODBC
Replies
3
Views
39
jrbarnett
jrbarnett
apocalypse11
  • Locked
  • Question
database slow via mapped drives
Replies
5
Views
71
MasterRacker
MasterRacker
haddaway
  • Locked
  • Question
Choosing between ODBC and OLEDB? 2
Replies
2
Views
34
foxdbs
foxdbs
babeo
  • Locked
  • Question
ODBC error or what is it?
Replies
1
Views
48
r937
r937
incagold
  • Locked
  • Question
Excel - Search for a cell that contains the information in a variable
Replies
2
Views
32
incagold
incagold

Part and Inventory Search

Sponsor

Back
Top