How I can transport data from excel into ZView?
480622
you can try converting data to CSV format (comma separated variables)  in Exceel and loading in ZView
1020179
In Outlook Express:\n\nFile\nImport\n\nIn Outlook:\nFile\nExport
332491
Try digdb excel add-in\n\nthis is the linke you need
257678
Make an ODBC of the MS Excel file and your connection string will be like :-\n\nConnString = "DSN=myDsn;Uid=username;Pwd=;"\n\nOr there is another way of doing it directly:-\n\nConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:&#92;MyExcel.xls;Extended Properties=""Excel 8.0;HDR=Yes;IMEX=1"""
23103
ry\nhttp://docs.sun.com/app/docs/doc/805-5080/6j4q7emgc?a=view
1046045
<%\n' Selected constants from adovbs.inc\nConst adOpenStatic = 3\nConst adLockPessimistic = 2\n\nDim cnnExcel\nDim rstExcel\nDim I\nDim iCols\n\n' This is all standard ADO except for the connection string.\n' You can also use a DSN instead, but so it'll run out of the\n' box on your machine I'm using the string instead.\nSet cnnExcel = Server.CreateObject("ADODB.Connection")\ncnnExcel.Open "DBQ=" & Server.MapPath("xl_data.xls") & ";" & _\n"DRIVER={Microsoft Excel Driver (*.xls)};"\n\n' Same as any other data source.\n' FYI: TestData is my named range in the Excel file\nSet rstExcel = Server.CreateObject("ADODB.Recordset")\nrstExcel.Open "SELECT * FROM TestData;", cnnExcel, _\nadOpenStatic, adLockPessimistic\n\n' Get a count of the fields and subtract one since we start\n' counting from 0.\niCols = rstExcel.Fields.Count\n%>\n<table border="1">\n<thead>\n<%\n' Show the names that are contained in the first row\n' of the named range.  Make sure you include them in\n' your range when you create it.\nFor I = 0 To iCols - 1\nResponse.Write "<th>"\nResponse.Write rstExcel.Fields.Item(I).Name\nResponse.Write "</th>" & vbCrLf\nNext 'I\n%>\n</thead>\n<%\nrstExcel.MoveFirst\n\n' Loop through the data rows showing data in an HTML table.\nDo While Not rstExcel.EOF\nResponse.Write "<tr>" & vbCrLf\nFor I = 0 To iCols - 1\nResponse.Write "<td>"\nResponse.Write rstExcel.Fields.Item(I).Value\nResponse.Write "</td>" & vbCrLf\nNext 'I\nResponse.Write "</tr>" & vbCrLf\n\nrstExcel.MoveNext\nLoop\n%>\n</table>\n\n<%\nrstExcel.Close\nSet rstExcel = Nothing\n\ncnnExcel.Close\nSet cnnExcel = Nothing\n%>
492062
It can't be done directly, but porting it via RealBasic is an option (and at that point, you could build your app out to Mac, Windows or Linux).\n\nhttp://www.realbasic.com/support/whitepapers/portingvisualbasic/
771576
You posted twice, please see my earlier answer.\n\nJust save it as a regular Excel spreadhseet and email it as a file attachment. All should be fine.
274376
Import it in to your contacts. File>Import and Export>Import from another program or file.
74701
false, the speadsheet would need to interface with something else to import data, alone it is mearly a spreadsheet.
131728
There are several ways to go about this, depending on how you have already entered data and what exactly you want it to look like.\n\nDid you already enter data into Excel?  Is it in the format: 9'3", 9'4", etc.?\n\nIs this data entered along a row (across) or a column (vertical), or some other layout?\n\nDo you want Excel to show the data in that same format (i.e. 9'3") or do you want it to say something like 9.25 ft?\n\nAny oher specific information I should know about what you're trying to do?  This way I can give you a useful answer.
776711
http://www.contextures.com/xlDataVal13.html
384146
You can go to Microsoft Excel if your computer has it and type out all the words.  Highlight the entire column and then hit the button on the toolbar with the picture of A Z and an arrow pointing down (that's the Sort Ascending button)
978587
E-Z! Get the SUPER converter from http://www.erightsoft.com/\nIt's got everything written out for you, and it utilizes drag-n-drop.
497451
Create a PivotTable report   \nShow All\nHide All\nOpen the workbook where you want to create the PivotTable report (PivotTable report: An interactive, crosstabulated Excel report that summarizes and analyzes data, such as database records, from various sources, including ones that are external to Excel.). \nIf you are basing the report on a Web query (Web query: A query that retrieves data stored on your intranet or the Internet.), parameter query (parameter query: A type of query that, when you run it, prompts for values (criteria) to use to select the records for the result set so that the same query can be used to retrieve different result sets.), report template (report template: An Excel template (.xlt file) that includes one or more queries or PivotTable reports that are based on external data. When you save a report template, Excel saves the query definition but doesn't store the queried data in the template.), Office Data Connection file, or query file, retrieve the data into the workbook, and then click a cell in the Microsoft Excel list (list: A series of rows that contains related data or a series of rows that you designate to function as a datasheet by using the Create List command.) containing the retrieved data.\n\nIf the retrieved data is from an OLAP (OLAP: A database technology that has been optimized for querying and reporting, instead of processing transactions. OLAP data is organized hierarchically and stored in cubes instead of tables.) database, or the Office Data Connection returns the data as a blank PivotTable report, continue with step 6 below.\n\nIf you are basing the report on an Excel list or database, click a cell in the list or database.\n\nOn the Data menu, click PivotTable and PivotChart Report. \nIn step 1 of the PivotTable and PivotChart Wizard, follow the instructions, and click PivotTable under What kind of report do you want to create? \nFollow the instructions in step 2 of the wizard. \nFollow the instructions in step 3 of the wizard, and then decide whether to lay out the report onscreen or in the wizard. \nUsually you can lay out the report onscreen, and this method is recommended. Use the wizard to lay out the report only if you expect retrieval from a large external data source to be slow, or you need to set page fields (page field: A field that's assigned to a page orientation in a PivotTable or PivotChart report. You can either display a summary of all items in a page field, or display one item at a time, which filters out the data for all other items.) to retrieve data one page at a time. If you aren't sure, try laying out the report onscreen. You can return to the wizard if necessary.\n\nDo one of the following: \nLay out the report onscreen\n\nFrom the PivotTable Field List window, drag the fields with data that you want to display in rows to the drop area labeled Drop Row Fields Here. \nIf you don't see the field list, click within the outlines of the PivotTable drop areas, and make sure Show Field List  is pressed in.\n\nTo see what levels of detail are available in fields that have levels, the click  next to the field.\n\nDrag fields with data that you want to display across columns to the drop area labeled Drop Column Fields Here. \nDrag fields that contain the data that you want to summarize to the area labeled Drop Data Items Here. \nOnly fields that have the  or  icon can be dragged to this area.\n\nIf you add more than one data field, arrange these fields in the order you want: Right-click a data field, point to Order on the shortcut menu, and use the commands on the Order menu to move the field.\n\nDrag fields that you want to use as page fields to the area labeled Drop Page Fields Here. \nTo rearrange fields, drag them from one area to another. To remove a field, drag it out of the PivotTable report. \nTo hide the drop area outlines, click a cell outside the PivotTable report.\n\nNote  If data is very slow to appear as you lay out the report, click Alw
100785
You will need to write a program that acts as a screen scraper to pull the data you want. This will be hard if you are not a programmer.\n\nPossibly creating a link in your excell to get a spreadsheet of data for a stock would help you???\n\nhere is how to do it:\nPut each of these items into cells A6 through A20\nThis will allow you to change each item which are the stock symbol (lrw in this case) start and end dates.\nhttp:/ /ichart.finance. yahoo.com /table.csv?s=   (remove the spaces I did them so it could be read)\nlrw\n&a=\n0\n&b=\n1\n&c=\n1982\n&d=\n1\n&e=\n21\n&f=\n2006\n&g=d&ignore=.csv\n\nin cell A4 put:\n=CONCATENATE(A6,A7,A8,A9,A10,A11,A12,A13,A14,A15,A16,A17,A18,A19,A20)\n\nand in cell A3 put"\n=hyperlink(A4,"Get Spreadsheet of historical data") \n\nnow click on the link and watch the chart load into a new spreadsheet.\n\nI know its not quite what you asked for but now you can graph and analyze the data for your favorite stocks.\n\nhttp://ichart.finance.yahoo.com/table.csv?s=bzh&a=0&b=1&c=1982&d=1&e=21&f=2006&g=d&ignore=.csv
117899
Have you tried Crystal XI - they have extended their db access methods. However you could always use ODBC or OLEDB...