Maximum Columns in Table

[TotallyConfused]

Is there a maximum number of Columns allowed in a table? Thank you.

 

[John W. Vinson]

Is there a maximum number of Columns allowed in a table? Thank you.

Yes; an absurdly huge 255. (30 columns is a VERY wide table).

Search the online help for "Specifications".

 

[Jeanette Cunningham]

255 fields - called fields (not columns) in access tables.

Jeanette Cunningham

 

[Larry Daugherty]

Hi Jeanette,

Not to bust your bubble but Columns and Rows are the defined terms for
RDBMS - I think it goes all the way back to E.F. Codd & C.J. Date. I
prefer and use "fields and records" and try to accept other usage
without quibble. It does get me though when people refer to controls
as "fields".

You seem to have suddenly appeared in the Access newsgroups and have
really been solving peoples problems. Kudos!

 

[Jeanette Cunningham]

Thanks Larry,
I will take a wider view next time. Thanks for the kind words - I enjoy
helping people. Sometimes I have to watch myself or I will try to answer too
many questions, I just want to help.

Jeanette Cunnningham

 

[Pat Hartman]

And all this time I thought rows were called "tupples" -- LOL

 

[John W. Vinson]

Thanks Larry,
I will take a wider view next time. Thanks for the kind words - I enjoy
helping people. Sometimes I have to watch myself or I will try to answer too
many questions, I just want to help.

That's how it starts, Jeannette. Then you get drawn in, addicted, and end up
sitting on the curb outside the wifi coffeehouse with your laptop, muttering
"I'll just answer one or two more posts..." <g>

Great to have you here. For some time I've been checking the newsgroups, and
if I see your name in a reply saying either "Well, that question's taken care
of, I needn't download it" or looking to see what elegant solution you've
posted.

 

[Cydney]

I have a huge CSV file that I need to get into columns and rows (comma
delimited). I tried to pull it into Access, but with the 255 column
limitation, I can't get it all in there. There are over 2500 columns and rows
in a numbered grid.

Any suggestions?

 

[John W. Vinson]

I have a huge CSV file that I need to get into columns and rows (comma
delimited). I tried to pull it into Access, but with the 255 column
limitation, I can't get it all in there. There are over 2500 columns and rows
in a numbered grid.

Any suggestions?

You'll probably need to write VBA code to read it into a 2500 element array,
and parse it out into a normalized tall-thin table structure.

I'm not quite sure what you mean by "CSV file (which has columns and rows
comma delimited already) into columns and rows" - what is the desired end
product here?? Access Tables, SQL/Server tables, another text file...?

 

[Cydney]

CSV is just a comma delimited text file. The end result needs to be Excel. I
believe I've found a solution by parsing it into separate sheets in Excel and
selecting to "transport" only the columns that will fit. It will take some
time to do manually, but I don't have time to create a macro tool to do the
process for me. If you know of one already written, that would help me. But
in lieu of that... I'm plugging away.. chunk by chunk...

 

[John W. Vinson]

CSV is just a comma delimited text file. The end result needs to be Excel. I
believe I've found a solution by parsing it into separate sheets in Excel and
selecting to "transport" only the columns that will fit. It will take some
time to do manually, but I don't have time to create a macro tool to do the
process for me. If you know of one already written, that would help me. But
in lieu of that... I'm plugging away.. chunk by chunk...

That's just what I'd need to do to get it into Access, so I fear I can't be
much help! Good luck!