>hey everyone,
>when i am appending from an xls file, is there a way that i can append just for selected columns. that is, can i append *.xls XLS for column = 1.....?
>will foxpro recoginize the column as 1 or A? basically, i just want to append certain columns from the spreadsheet into the foxpro table. also, is it possible once the condition is set to do something like:
>append *.xls XLS for column = 1, " ", " ", "BOB", Column = 3..........
>The reason for this is because the spreadsheet i have doesn't match up with the foxpro table even if i can select only certain rows. some of the columns in the foxpro table need to be null. can anyone help with this? i'll be more than happy to try to explain in greater detail if this is hard to understand. thanks.
You can create table/cursor that matches the spreadsheet columns and APPEND XLS to it. After that you can move only columns you need from that table/cursor into your table.
--sb--