Search String: Display: Description: Sort:

Results:

References: [ +subject:/^(?:^\s*(re|sv|fwd|fw)[\[\]\d]*[:>-]+\s*)*Importing\s+from\s+Excel\s*$/: 2 ]

Total 2 documents matching your query.

1. Importing from Excel (score: 1)
Author: P.J.Wells@open.ac.uk
Date: Wed, 22 Jan 2003 19:47:28 -0000
My dataset of accounting data on 110,000 companies has its primary existence in the form of Excel spreadsheets. Each year's data is stored in a directory containing 13 spreadsheet files (with columns
/archives/html/s-news/2003-01/msg00130.html (10,559 bytes)

2. Re: Importing from Excel (score: 1)
Author: "Michael Schmidt" <Michael.Schmidt2@verizon.net>
Date: Wed, 22 Jan 2003 15:15:22 -0500
Perhaps this isn't the most elegant answer available, but the 10 minute answer is to import the 13 spreadsheets into a single Access database, ensure that each company has a common identifier (number
/archives/html/s-news/2003-01/msg00131.html (13,850 bytes)


This search system is powered by Namazu