It's been ages since I used Excel, but I wanna say 32 thousand rows/columns? ^_^
Come to think of it, QuickBooks and Peachtree both have functions that let you export data from their files (which are standard, multi-table, relational databases) into flat-file Tab/CSV's (QB's are called IIF's but they're still structurally Tab-delimited files) -- Mostly useful for reporting or looking for data anomalies, but they can be used as a kludgy, last-resort data recovery method when all other possibilities have been exhausted; both programs have functions that let you import the CSVs into a new file, but transaction links are not necessarily properly maintained. This is juuust a bit of an issue for programs where 95% of what the users work with on a daily basis are documents based upon query results that pull from a minimum of four linked tables each...o_O
Come to think of it, QuickBooks and Peachtree both have functions that let you export data from their files (which are standard, multi-table, relational databases) into flat-file Tab/CSV's (QB's are called IIF's but they're still structurally Tab-delimited files) -- Mostly useful for reporting or looking for data anomalies, but they can be used as a kludgy, last-resort data recovery method when all other possibilities have been exhausted; both programs have functions that let you import the CSVs into a new file, but transaction links are not necessarily properly maintained. This is juuust a bit of an issue for programs where 95% of what the users work with on a daily basis are documents based upon query results that pull from a minimum of four linked tables each...o_O
Comment