mac os x Excel odbc text driver

[paulc]

I need Excel to read text files via odbc (files have more than 65536 rows)
and use them in pivot tables. I've scoured the net but cannot find any
suitable text drivers for odbc. Older versions of Excel had text drivers
supplied but MacOffice2004 does not!

Anyone help please?

 

[Jim Gordon MVP]

Hi Paul,

As it turns out there is a new article on MacTopia that probably answers
your question. It's here:

<http://www.microsoft.com/mac/products/excel2004/using.aspx?pid=usingexcel20
04&type=howto&article=/mac/LIBRARY/how_to_articles/office2004/xl_ODBC.xml>

There is a link to OBDC drivers in the article.

OpenLink has announced that they plan to make their drivers open source some
day.

-Jim

--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info

 

[Jim Gordon MVP]

Hi again,

I forgot to mention that the number of rows in the source database is
determined by the database application itself, not by Excel or ODBC.

Excel has a maximum capacity of 65,536 rows per worksheet, but you can have
as many worksheets as you want to until you've used up your computer's
memory and hard drive (essentially there is no limit to the number of
worksheets).

So be sure to keep the result set of your queries to less than 65,536 rows
when importing into Excel.

I have a workbook that has 256,000 rows in it. Excel 2004 is the only
version of Excel either Mac or Windows (including XL 2003 on a very robust
Windows box) that can manipulate the data and print any portion of it, so
you're using the best tool available.

-Jim
--
Jim Gordon
Mac MVP

MVPs are not Microsoft Employees
MVP info