combining fields

A

akfish

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!
 
J

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!
Click to expand...

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]
 
A

akfish

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
 
J

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?
Click to expand...

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]
 
A

akfish

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?
 
J

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?
Click to expand...

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

John W. Vinson[MVP]
 
Top