Question about Microsoft Excel 2000 Step by Step (1572319747) for PC

1 Answer

Excel Loading Problem

Hi All,
I have a problem in loading excel sheet from Windows Application i.e(VB.NET 2005) one of the column in excel sheet has mixed data type so while i am loading that column into my Grid it loads numeric values and some times it loads only text values .I have also set the IMEX =1 in the connection string property.It Doesn't work even then.So can any one send me the solution of retrieving mixed datatype column values from the excel.........

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.


    An expert who has answered 20 questions.


    An expert that hasĀ over 10 points.


    An expert whose answer gotĀ voted for 2 times.

  • Contributor
  • 22 Answers
Re: Excel Loading Problem

Try using instead of Microsoft Office. It should work and it's free.

Posted on Dec 10, 2007

Add Your Answer

0 characters

Uploading: 0%


Complete. Click "Add" to insert your video. Add


3 Points

Related Questions:

1 Answer

Why did i choose microsoft excel lab?

To create some spread sheet of datas.
Crate some Commercial calculation as well as Graphical charts such as pie chart,bar chart .
Excel is ocean bro.

Jul 09, 2014 | Educational & Reference Software

1 Answer

I want to copy an Excel chart as a Image onto a PowerPoint Slide (Office 2007). What is the sequence of APIs to apply?

Copy worksheet data to a PowerPoint presentation
  1. In Excel, select the worksheet data that you want to copy to a PowerPoint presentation.
  2. On the Home tab, in the Clipboard group, click Copy za006044679.gif.


Keyboard shortcut You can also press CTRL+C.

  1. Click in the PowerPoint presentation where you want to paste the copied worksheet data.
  2. On the Home tab, in the Clipboard group, click Paste.

Keyboard shortcut You can also press CTRL+V.

  1. Click Paste Options za006043532.gif next to the data, and then do one of the following:
    • To use the original format of the copied data, click Keep Source Formatting.
    • To use the document theme that is applied to the PowerPoint presentation, click Use Destination Theme.
    • To paste table data that you copied as text, click Keep Text Only.


  • If you don't see the Paste Options button, you may have to turn it on. Click the Microsoft Office Button za010077102.gif, and then click PowerPoint Options. In the Advanced category, under Cut, Copy, and Paste, select the Show Paste Options buttons check box.
  • If you paste the data into a PowerPoint table, the Paste Options button is not displayed.
  • To paste the data in another format (such as a worksheet object, HTML format, bitmap, picture, or to text format) or to paste a link to the source data in Excel, on the Home tab, in the Clipboard group, click the arrow on the Paste button, and then click Paste Special. In the As list, click the format that you want to use.
    • If you want to edit the entire worksheet later, click Microsoft Office Excel Worksheet Object. Clicking Microsoft Office Excel Worksheet Object provides access to the entire worksheet in the presentation, including data that you may want to keep private. To automatically update the table in the presentation when changes are made to the source data in Excel, click Paste link. Both of these options also preserve the Excel formatting, even when the formatting features that are used are not supported in PowerPoint. If you saved the source workbook before you copied the data, you can also click Attach Hyperlink to insert a hyperlink in your presentation that directs you to the source data in Excel.
    • To paste the content as an Object Linking and Embedding (OLE) (OLE: A program-integration technology that you can use to share information between programs. All Office programs support OLE, so you can share information through linked and embedded objects.) PowerPoint application icon (rather than pasting the actual content), click Microsoft Office Excel Worksheet Object, and then select the Display as icon check box. You can click the icon to open the application and then view the content.
    • If you want to use HTML to copy the data to PowerPoint into a PowerPoint table, click HTML format.
    • To paste a static picture, click Device Independent Bitmap or Bitmap, or to paste a picture that can be ungrouped, click Picture (Enhanced Metafile) or Picture (Windows Metafile).
    • To paste the data as formatted or unformatted text, click Formatted Text (RTF) or Unformatted Text.
  • To paste the data as a hyperlink that directs you to the source data in Excel, click the arrow on the Paste button, and then click Paste As Hyperlink. If the workbook that contains the source data has not been saved yet, this option is unavailable.
  • If you want the range of data that you paste as a Microsoft Excel Worksheet Object into a PowerPoint presentation to expand when the corresponding data expands on the Excel worksheet, you can define a name (name: A word or string of characters that represents a cell, range of cells, formula, or constant value. Use easy-to-understand names, such as Products, to refer to hard to understand ranges, such as Sales!C20:C30.) for the range of data in Excel before you copy the data. You can then paste a link to the named range by using the Paste Special command. On the Home tab, in the Clipboard group, click the arrow on the Paste button, click Paste Special, and then click Paste link. This works only when you copy data that is not in table format in Excel.

Mar 09, 2011 | Individual Software Professor Teaches Word...

2 Answers

What is ms-excel

ms excel is a program that you can make graphs and set up all sorts of things like prices at a petrol station on the front neon sign you can set it up that each time the price rises it will automatically increase that rise in dollars and cents
hope this helps

Feb 15, 2011 | Broderbund Learn MS Windows XP and Excel...

1 Answer

How i recover my demages excell files

Close down Excel, re-open it and try to open the file again.
If this doesn't work, restart the computer, open up Excel and try to open the file again.
If this doesn't work, delete the contents of your c:windows emp directory then reboot. Try again
If this doesn't work, open Excel in Safe Mode. This will disable VBA and Add-ins.
  • Click on Start then Run then enter (including the quotes and the /s extension): "C:Program FilesMicrosoft OfficeOfficeexcel.exe" /s ["C:Program FilesMicrosoft OfficeOffice10excel.exe" /s (for Excel 2002, Office XP, click cancel if the MS Office Installer starts, Excel in safe mode will still start)].
  • Try to open the file.
If this doesn't work, be sure to scan the file for viruses. If you don't find a virus, find the file in Explorer, right click on it and rename it, replacing the .xls extension with the .doc extension. Try to open it as Word document.

If this doesn't work, try to determine if the file is unrecoverable on the disk. Open the file in Explorer and try to copy it to another location.
  • If you can copy the file to another location, skip to step 9. If not, the actual sectors on the disk may be corrupted.
  • If the data is valuable enough to you, seek professional services as a damaged hard disk file recovery is not for the faint at heart.
If the recovered file won't open or you could copy the file to another location, try to open the file in a more recent version of Excel. As the version numbers increase, their ability to recover corrupt files increases. If this doesn't work or such a version of Excel is not available, see if some other spreadsheet application is and try to open the file in that program.

If Microsoft can't help you (see the tips section) and you've exhausted all the free methods above for damaged disk recovered or copyable files there are a number of excellent commercial applications which will recover your files almost immediately.

Dec 10, 2010 | Educational & Reference Software

1 Answer

Cost of a portion of a sheet of plywood.

since 12*8=96 this implies that 96' costs 30$ .and 96" will cost 30/12=2.5$ since i feet equals 12 inches

Mar 05, 2010 | Vivendi Excel@ Mathematics Study Skills...

1 Answer


You will have to use a logic saying If subject1 > 34 and subject2 >34 and subject3 > 34. Idead is to tell the prog that all subjects have to be > 34 by using the AND function. If you use OR function, then the first subject having > 34 will complete the condition and you will get the result, which will be wrong. So, use the AND function. How? Use the help on Using functions in Excel or whatever you are using. They all have it inbuilt.

Aug 22, 2009 | Educational & Reference Software

1 Answer

Donwload multiple files from server to client using


//To Get the physical Path of the file(me2.doc)
string filepath = Server.MapPath("me2.doc");

// Create New instance of FileInfo class to get the properties of the file being downloaded
FileInfo myfile = new FileInfo(filepath);

// Checking if file exists
if (myfile.Exists)
// Clear the content of the response

// Add the file name and attachment, which will force the open/cancel/save dialog box to show, to the header
Response.AddHeader("Content-Disposition", "attachment; filename=" + myfile.Name);

// Add the file size into the response header
Response.AddHeader("Content-Length", myfile.Length.ToString());

// Set the ContentType
Response.ContentType = ReturnExtension(myfile.Extension.ToLower());

// Write the file into the response (TransmitFile is for ASP.NET 2.0. In ASP.NET 1.1 you have to use WriteFile instead)

// End the response

private string ReturnExtension(string fileExtension)
switch (fileExtension)
case ".htm":
case ".html":
case ".log":
return "text/HTML";
case ".txt":
return "text/plain";
case ".doc":
return "application/ms-word";
case ".tiff":
case ".tif":
return "image/tiff";
case ".asf":
return "video/x-ms-asf";
case ".avi":
return "video/avi";
case ".zip":
return "application/zip";
case ".xls":
case ".csv":
return "application/";
case ".gif":
return "image/gif";
case ".jpg":
case "jpeg":
return "image/jpeg";
case ".bmp":
return "image/bmp";
case ".wav":
return "audio/wav";
case ".mp3":
return "audio/mpeg3";
case ".mpg":
case "mpeg":
return "video/mpeg";
case ".rtf":
return "application/rtf";
case ".asp":
return "text/asp";
case ".pdf":
return "application/pdf";
case ".fdf":
return "application/vnd.fdf";
case ".ppt":
return "application/mspowerpoint";
case ".dwg":
return "image/vnd.dwg";
case ".msg":
return "application/msoutlook";
case ".xml":
case ".sdxl":
return "application/xml";
case ".xdp":
return "application/vnd.adobe.xdp+xml";
return "application/octet-stream";

Good Luck

Aug 17, 2009 | Microsoft Designing ASP.NET Applications...

1 Answer

Before occuring this problem I was run Scan DIsk & Defregment also after that I am facing this message "Microsoft Excel for Windows has encountered a problem and needs to close. We are sorry for the...

left click start, left click control panel, left click add/remove programs, locate microsoft office highlight it and left click change, once the window opens click on repair. This should perform a repair on your Microsoft Office Application. Restart the computer if necessary, also be sure to pull down any Windows Updates left click start, left click Windows Updates, there could very well be an update your Excel application is missing. The Microsoft Updates have been known to resolve some of the known issues with office applications.

Jun 16, 2009 | Microsoft Excel Version 2002 Step by Step...

Not finding what you are looking for?
Microsoft Excel 2000 Step by Step (1572319747) for PC Logo

Related Topics:

108 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Educational & Reference Software Experts


Level 3 Expert

7983 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers


Level 3 Expert

18257 Answers

Are you a Microsoft Educational and Reference Software Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides