Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement