Is your main program written in Visual FoxPro, or in .NET? I will assume Visual FoxPro.
Basically, you need to learn Excel Automation - controlling Excel from Visual FoxPro. It really isn't very complicated; I wrote an introductory article, available at
http://www.utmag.com/wconnect/wc.dll?9,7,10,1562In simple cases, you can also save the Excel file in DBF format, and then import that into Visual FoxPro. This might also be automated from Visual FoxPro.
HTH,
Hilmar.
>Hi!
>I'd like to ask help to all the gurus, i have this application which will let you import data from an ms excel format. Say, I had a list of inventory items (summing up to 2,000+) instead of inputting those items again to my application, i will just provide an option to browse the excel file and do the importing of the data.
>
>How will i go about this? What commands to be used?
>
>Any help would be greatly appreciated. Thank you!
>
>Alfred N. Roa
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)