Instructions to Create the ImpactTest383.txt File Are Not Clear in Walkthrough (823999)


The information in this article applies to:

  • Microsoft Visual Studio Tools for the Microsoft Office System version 2003

SUMMARY

A walkthrough named "Writing Data from a Text File to a Worksheet" is included in the Microsoft Visual Studio Tools for the Microsoft Office System documentation. In this walkthrough, the instructions for creating the ImpactTest383.txt file are not clear. Because of this, you may create a text file for the walkthrough that is not correctly formatted. This article discusses where you can download a correctly formatted text file to use with this walkthrough.

MORE INFORMATION

To locate the "Writing Data from a Text File to a Worksheet" walkthrough, visit the following Microsoft Web site:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_wrcore/html/wrwlkusingadonettoexchangedatawithdatabase.asp

The steps in the "Creating the Data File" section instruct you to copy a section of text, paste the text into Notepad, and then save the file as ImpactTest383.txt. However, the instructions for formatting the text file with tabs are not clear.

WORKAROUND

Instead of manually creating the ImpactTest383.txt file, you can use the text file in the completed sample "Excel Worksheet Using ADO.NET." To download the ImpactTest383.txt file, visit the following Microsoft Web site:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_wrcore/html/wrsamsamplespreadsheetwithtextpulledbyadonet.asp

To use the text file that is included in the "Excel Worksheet Using ADO.NET" sample with the "Writing Data from a Text File to a Worksheet" walkthrough, follow these steps:
  1. Follow the steps in the "Creating a New Project" section of the walkthrough to create the My Excel Data Reader project.
  2. Follow the steps in the "Setting up the Worksheet" section of the walkthrough.
  3. Download the "Excel Worksheet Using ADO.NET" sample, and then copy the ImpactTest383.txt file from the sample to the folder that contains the My Excel Data Reader project.
  4. Open the ImpactTest383.txt file in Notepad.
  5. Delete the following two lines, and then save your changes to ImpactTest383.txt:

    BatchDate 23-07-02
    Technician JRoberts
  6. Skip the "Creating the Data File" section in the walkthrough, and then complete the remaining sections in the walkthrough.

REFERENCES

For more information about Microsoft Visual Studio Tools for the Microsoft Office System, visit the following Microsoft Web site:

http://msdn.microsoft.com/library/en-us/dv_wrcore/html/oriIntegratingOfficeComponents2.asp

Modification Type:MinorLast Reviewed:2/3/2006
Keywords:kbnofix KB823999 kbAudDeveloper
©2004 Microsoft Corporation. All rights reserved.