dantheinfoman
Programmer
Hi All,
I'm wondering if it's possible to load an excel file into a cursor or directly to a grid (or just some way to analyze the column headers or record number 1 or 2 in foxpro). So consider this crummy example excel file. Let's also pretend that the commas below represent delimiting between different cells in Excel.
Emp, LName, Fname
100, Jones, Billy
101, Smith, John
102, Doe, Jane
I'm wanting a way to look at items without having to know what fields are (character, logical, etc) nor how big they are. I just want to look at the data as it is and then determine how I want to classify it later.
Anyone have any experience in analyzing excel files and importing or manipulating the data. I just want to look at it using Foxpro without knowing anything about the order of Excel fields, because files may be different all the time.
Thanks
Dan
I'm wondering if it's possible to load an excel file into a cursor or directly to a grid (or just some way to analyze the column headers or record number 1 or 2 in foxpro). So consider this crummy example excel file. Let's also pretend that the commas below represent delimiting between different cells in Excel.
Emp, LName, Fname
100, Jones, Billy
101, Smith, John
102, Doe, Jane
I'm wanting a way to look at items without having to know what fields are (character, logical, etc) nor how big they are. I just want to look at the data as it is and then determine how I want to classify it later.
Anyone have any experience in analyzing excel files and importing or manipulating the data. I just want to look at it using Foxpro without knowing anything about the order of Excel fields, because files may be different all the time.
Thanks
Dan