combining fields

[Guest]

Hello, I have 300 fields (columns) of data that I would like to append all to
one single field (column). Any suggestions would be appreciated.
Thanks!

 

[John Vinson]

Hello, I have 300 fields (columns) of data that I would like to append all to
one single field (column). Any suggestions would be appreciated.
Thanks!

Well, you don't have 300 fields in an Access database, since Access is
limited to (an absurdly wide) 255 fields.

What's the context? Where is this data currently stored? Do you want
to create a Memo field with all 300 (text?? other datatype?) values
all jammed together into one horrendously denormalized field?

I really suspect that if you could describe what you're trying to
ACCOMPLISH there will be an easier way.

John W. Vinson[MVP]

 

[Guest]

OK more information. I have an ascii file which I exported from ARCGIS
consisting of up to 300 columns of data (about 100 rows each)representing a
topographic value (range 0-500 meters) at a particular map coordinate. I wish
to count the number of values in the entire grid that are less than 100
meters. This data should all be listed under a single field but it was not
exported as such. I would like to use Access to append these columns to each
other so that analysis in Access will be easier. It looks like I can only
bring in 255 of the columns at a time but can I import them to 1 column or
can I write a query to do this?

Thanks

 

[John Vinson]

OK more information. I have an ascii file which I exported from ARCGIS
consisting of up to 300 columns of data (about 100 rows each)representing a
topographic value (range 0-500 meters) at a particular map coordinate. I wish
to count the number of values in the entire grid that are less than 100
meters. This data should all be listed under a single field but it was not
exported as such. I would like to use Access to append these columns to each
other so that analysis in Access will be easier. It looks like I can only
bring in 255 of the columns at a time but can I import them to 1 column or
can I write a query to do this?

For this case, I'd suggest writing some VBA code to read the file as
text, and open a Recordset based on a table, writing out each value.

Do you want, what, a tall skinny table with the coordinates, one data
field, and 30000 rows?

John W. Vinson[MVP]

 

[Guest]

Thanks very much John for the reply. yes I wold be looking for one tall table
with coordinates. Would I apply the VBA as a macro?

 

[John Vinson]

Thanks very much John for the reply. yes I wold be looking for one tall table
with coordinates. Would I apply the VBA as a macro?

No, as a Module - executed from a click event of a command button (or
some other suitable event).

John W. Vinson[MVP]