I have an excel file that I need to import. I need to analyze the data, make some changes to the data, rename some fields etc... Then create a new dbf from that. So Ideally, I would like to import it into a cursor. Is that possible. My second choice would be a free table.
Looking at the "IMPORT" function, it seems to want a database name and a table name.
I tried the function with just a table name but the syntax is not correct.
IMPORT FROM (lcSource) NAME 'xlsimport' TYPE XLS
I have a final structure that is pre-defined so I could use an append from, but that doesnt allow for my data changes. Not all the fields have the same name as the source xls file.