General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Handy COPY FROM functionality?
I am writing a utility to import Quickbooks customer and charge data. The IIF file (tab-delimited ascii) contains a header record which lists the field names. I need to support multiple versions of Quickbooks and I am not sure if the exported ascii files are identical in each version. However, I do believe that the field names will remain consistent (at least the basic ones I need).
What I would like to do is to create a cursor with the field names matching the field list provided in the ascii file. Then I would be able to simply reference the fields I want, and I don't need to worry about extra fields or varying field orders.
I know how to create the cursor programatically by extracting the header record, but am I missing something? Does foxpro already have a function to handle this?
Just curious?
Thanks,
David
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