Information générale
Titre:
Importing from Excel 97 to VFP
I've been given about 100 Excel 97 spreadsheets, and would like to extract the data from a particular named range (XDATA) that exists within each spreadsheet, and consolidate it into a single VFP database. I'm sure there's a way to consolidate the data using VBA, but I'm not familiar enough with that product to know where to start. There doesn't appear to be a native way to this in VFP. However, I wonder if anyone knows a way (perhaps using OLE) to do this. Thanks!!
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement