Is there a way to do a select statement to get the first 147 fields of a table (and then another one for the second 147 fields) without typing all the field names?
I'm importing them into Excel with DTS and can't do it all at once since Excel limits me to 256 columns. It would also be ok if I could get the DTS to collect the first 256 columns and then I could get the rest.
Or maybe there's a way to exclude fields with certain characters in the field name (92 in my case) to lower the number of fields I get.
Thank you.
I'm importing them into Excel with DTS and can't do it all at once since Excel limits me to 256 columns. It would also be ok if I could get the DTS to collect the first 256 columns and then I could get the rest.
Or maybe there's a way to exclude fields with certain characters in the field name (92 in my case) to lower the number of fields I get.
Thank you.