You should import the data into ACCESS, then you can use a pivot table, or
an External Data Query, to bring into Excel the results of a query, which
would be a subset of rows so that Excel could handle them within its
limitations.
Both Pivots and Queries are found in the DATA menu in Excel. If you are
using Office 2002 (XP) or 2003, the wizards are good enough to take you
through the steps. The help in Excel does not reveal everything you can do
with these, however. The query language is MS Transact-SQL, but again, the
wizards are adequate so you don't have to learn that to get good results.
Pivots are installed by default but queries are usually only installed on
first use. You also have to install the ODBC drivers, which control which
data you are searching (Access is not the only data you can query, so you
have to tell Excel which driver to use). You will get nagged for security
updates if this is the first time you installed Data drivers, since there
have been many patches. All in all, its a pretty straight-forward and
simple install if you have the Office CD with Access on it, and an internet
connection.
Tom Turak
-----Original Message-----
From: Jenny Hurley [mailto:[log in to unmask]]
Sent: Monday, January 26, 2004 8:09 AM
To: [log in to unmask]
Subject: [PCSOFT] Importing External Data to Excel
Subject: Importing more than 65,556 rows into EXCEL
I have a file with one million rows. I can import 65,556 rows and that is
the limit for a page in Excel. How do I import the remainder files into
Excel? Thanks, Jenny
PCSOFT maintains many useful files for download
visit our download web page at:
http://freepctech.com/downloads.shtml
Do you want to signoff PCSOFT or just change to
Digest mode - visit our web site:
http://freepctech.com/pcsoft.shtml
|