P
Peter
I am importing large, 60 field 300,000 record csv files and am quickly
overloading Access. I need to query each table, once imported (all fields as
text), to find which field are all or mostly null or ZLS. Then I can delete
these fields. So, I need a query that results in just 2 records. The first
record would all the field names in the table and the second would be the
total number of nulls or ZLS in that field.
I can do it for one filed at a time but not for more than that.
And, pushing my luck, is there a way to control the length of a text field
during the import process? My default text field length is 50 set in
Tools>Options but they still come in at 255 when I import. Although I can
change field type and indexing during the import I cannot see how to change
the text field length.
Please accept my apologies if I am missing the blindingly obvious.
I am using Access 2003 on Vista (with 4GB ram).
As usual thank you in anticipation for your help and time.
Peter
overloading Access. I need to query each table, once imported (all fields as
text), to find which field are all or mostly null or ZLS. Then I can delete
these fields. So, I need a query that results in just 2 records. The first
record would all the field names in the table and the second would be the
total number of nulls or ZLS in that field.
I can do it for one filed at a time but not for more than that.
And, pushing my luck, is there a way to control the length of a text field
during the import process? My default text field length is 50 set in
Tools>Options but they still come in at 255 when I import. Although I can
change field type and indexing during the import I cannot see how to change
the text field length.
Please accept my apologies if I am missing the blindingly obvious.
I am using Access 2003 on Vista (with 4GB ram).
As usual thank you in anticipation for your help and time.
Peter