General information
Category:
COM/DCOM and OLE Automation
>>>Hi, I am using the IMPORT FROM command to read in an Office 2007 MS-Excel file, so field names are A, B, ....Z, AA, AB, ...AZ, BA, BB, etc..
>>>
>>>I have to handle files defined as:
>>> Columns A - M: standard information
>>> Columns N - R: information about charge 1
>>> Columns S - W: information about charge 2
>>> Columns X - AB: information about charge 3
>>> etc.
>>>
>>>In other words, past column M, information is in groups of 5 columns.
>>>
>>>NOOOO problem, i thought. I have code that calculates the column name.
>>>
>>>BUT lo and behold! what column follows DU??? NO, NOT DV, but DW!
>>>
>>>What is going on here? any ideas? this is def. breaking my code.
>>>
>>>Any input is appreciated.
>>>
>>>Guess i have to change the code to using AFields()?
>>
>>The column is just not there. In MS-Excel it appears empty, and format is "general" - so i entered a "123" and changed the format to numeric.
>>
>>Still, no column DV in VFP.
>
>Is there any other Excel file you can try to import? The code I provided in my last message creates an ExcelColTest.xls file, what happens if you try to import that? You can change that code to 132 columns if necessary.
>
>Does your Excel file have more than one row? If so, can you test with half of the rows deleted (the top half)?
>
>Like I said, I can't duplicate your issue, I really think there's something weird with your Excel file.
>
>FWIW I'm on VFP9 SP2 build 7423 (the latest hotfix), not that I think it makes any difference from VFP9 SP1.
Hi Al, yes, thanks...when i delete 2 rows that have the data out to the DV column...no problem....will have to mess around w/it a bit more.
J
Previous
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