Unlimited columns

Question

Unlimited columns

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

Lowell SSC Guru Points: 323518 More actions · Answer 1

good luck; it's been a while since i fiddled with access, but i remember access 2000 had a 255 column limit; maybe the more updated version might not have that limitation;

I looked to see if the ADODB.Recordset had a limitation, but it appears that it does not, it only has a limitation imposed by the provider...ie the JET driver would impose a limit of 255, the SQLOLEDB provider a limit of 1024, etc... on it...so in theory, a disconnected recordset might not have the limitation(except the limitation of available memory on the box?);

maybe you can do your analysis in a program, and insert just the final results into a SQL table.

Lowell

--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

TNT79 SSC Enthusiast Points: 173 More actions · Answer 2

Thanks Lowell for the info!

Unfortunately, the Analysis process takes months - thus requiring permenant storage and fast data access!!

Regards,

TNT

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 3

TNT,

Just for grins, can you post the "header file" and a row or 2 of data (making sure, of course, there are no SSN's, account numbers, etc in the file)? I've got this nasty little idea in my head...

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

TNT79 SSC Enthusiast Points: 173 More actions · Answer 4

Hi Jeff

Apologies for the late response!

I have posted the files you requested!

HEADER FILE

</FIELDS>

DATA FILE

198808061087467916lcjvuvvisfxzhaavnauorraqqjfcngrfgvnkvvtgaxb1920632894681666365

193810231197410064hkworaepxvefmrsjsdgciptemyllbdtbmdjevoppijq243276826 265713799

Regards,

TNT