General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Appending selected columns from xls file
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.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only