Re: Excel worksheet names mangled by ODBC

Tech-Archive recommends: Fix windows errors by optimizing your registry

On Sun, 1 Jul 2007 06:36:00 -0700, Pak-Ming Cheung [MSFT]
<PakMingCheungMSFT@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

There is no problem in Access 2003 + Excel 2003 (link table):

I have an Excel file which contains several worksheets. One of them named as
"1A". When I use "File -> Get External Data -> Excel file" and select the
work*** "1A", the table name in Access is shown as "1A".

You may consider to re-post the question to the Access forum, since the ODBC
driver for Excel is not developed by our team. There should be more experts
in the Access forum to answer this question.

Ming.
MDAC Team, Microsoft.


Thanks for your reply. I have noticed that you can link Excel tables
in MS-Access two different ways: one through the MS-Access native
link method, the other by choosing "ODBC datasources" and then
choosing the Excel ODBC driver and browsing for the file. The first
method does not mangle the names, the second does. But I only have
the option of using the second method (via ODBC) because my
application is written in C++ without any COM features (it should
also run on Linux or Mac; of course, it will not be linking to Excel
files in those instances).

This is why I posted here instead of in the Access forum because it
is an ODBC issue, not an Access issue. The only reason I mentioned
MS-Access at all is to illustrate that the problem appears anywhere
the ODBC driver is involved, but it is not specific to MS-Access.

--
Bob Hairgrove
NoSpamPlease@xxxxxxxx
.

Quantcast