Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4
Default ODBC/OLE DB to access Excel file and get weired table name Sheet$_

I have a customer file, which contains a sheet named 'Sheet1'. I used ODBC
driver and OLE DB with jet provider to access the file. In both cases, I got
two table names returned to me. One is 'Sheet1$' as I expected. And the other
is 'Sheet1$_' which I would like to know where it came from ? I got an
in-existing table message when I tried to query the 'Sheet1$_' table. JSince
et engine returned me the table and why it told me the table does not exist
when I queried it ? Thanks.

P.S. Mail me please if you need to take a look at the file. I have created a
very small excel file for this testing purpose.
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
excel doing some weired stuff Jamal Excel Discussion (Misc queries) 4 April 21st 09 07:09 PM
Link an excel sheet to access table with pics The Greek Excel Discussion (Misc queries) 2 January 3rd 08 01:01 PM
Pivot Table - ODBC Link to Access db Kirk P. Excel Discussion (Misc queries) 2 February 22nd 07 08:19 PM
how to access databases from excel using ms query and odbc? Nabin Excel Discussion (Misc queries) 0 October 11th 06 07:32 AM
Appending Excel file to an Access table Diana[_5_] Excel Programming 1 September 10th 03 08:21 AM


All times are GMT +1. The time now is 10:07 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"