Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
using VFP 6.0 to import excel 2000 spreadsheet
- Thread starter hodge2
- Start date
darrellblackhawk
Programmer
Yes you can.
What are you trying to accomplish?
What are you doing in code?
How is the .xls file structured?
You can get at just about every item of an Excel spreadsheet through automation, but it's easier when you already know the structure of the file.
If your spreadsheet is contain text labels in the first row, and then, the data in the rows following that, you can use: append from filename.xls type xls - into a table.
Of course the table has to have the fields set-up appropriately.
Darrell
'We all must do the hard bits so when we get bit we know where to bite'
What are you trying to accomplish?
What are you doing in code?
How is the .xls file structured?
You can get at just about every item of an Excel spreadsheet through automation, but it's easier when you already know the structure of the file.
If your spreadsheet is contain text labels in the first row, and then, the data in the rows following that, you can use: append from filename.xls type xls - into a table.
Of course the table has to have the fields set-up appropriately.
Darrell
'We all must do the hard bits so when we get bit we know where to bite'
darrellblackhawk
Programmer
Sorry... Should read "If your spreadsheet contains"
Darrell 'We all must do the hard bits so when we get bit we know where to bite'
Darrell 'We all must do the hard bits so when we get bit we know where to bite'
- Thread starter
- #4
I created a dbf table with the same format as the spreadsheet. When I use an "append from filename.xls type xl8" the error message is: microsoft excel file format is invalid.
If I open the spreadsheet and save as Excel 5/95, then FoxPro has no problem. Is FoxPro 6.0 incompatible with the Excel which is part of Office 2000? Is there any way around this? I don't want my users to have to open Excel and save the file in a different format. I want them to just be able to run a FoxPro program to import the file.
If I open the spreadsheet and save as Excel 5/95, then FoxPro has no problem. Is FoxPro 6.0 incompatible with the Excel which is part of Office 2000? Is there any way around this? I don't want my users to have to open Excel and save the file in a different format. I want them to just be able to run a FoxPro program to import the file.
- Status
Similar threads
