ConnectToMicrosoftExcel
Exporting data from MV to Excel
- Create a CSV or other Tab-Delimited file. When a .csv file is opened with Excel you'll get a basic set of columns and rows.
- Use the AccuTerm FTD utility to import and export with .xls files. AccuTerm also has samples to use Excel formulas to access MV. See
- NebulaXLite allows creation of rich documents from BASIC, compared to plain data in cells.
Importing data from Excel to MV
- As above, see AccuTerm.
- See this blog entry for discussion of a possible future product as well as code to integrate Excel with MV via a web service: Search the blog for notes about integration with Microsoft Office applications like Outlook.
Direct Connectivity vs import/export
This can be accomplished with any connectivity code and Microsoft Office add-ins. Look into Microsoft VSTO (Visual Studio Tools for Office) to create the Excel integration piece. Other methods can be used such as XLAs or VBA macros. Excel development is a field unto itself. Use tools like UniObjects.NET, mv.NET, or ON.NET to do the actual connectivity directly into MV. For clients outside of the intranet, create the add-in with a web service interface and connect into any MV platform using standard web service methods. (TG)
See Also
There are various solutions on this site for converting Excel to CSV and parsing CSV to dynamic or dimensioned arrays.
Misc discussions
http://groups.google.com/groups?hl=en&q=group:comp.databases.pick+excel
Tags: excel csv spreadsheets
