Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. dillbeck

    Unresolvable DTS Error

    I exported the table as a text file with the CSV format. I examined the data in Excel. I saw nothing unusual. I then imported the CSV file into SQL Server. The result wasn't pretty (fld1, fld2,etc- all text and all at 255 bytes), but I ultimately got it right. Thanks again for your suggestions!
  2. dillbeck

    Unresolvable DTS Error

    Thanks for your suggestions. I will create a CSV export out of Access and take a look at the data and also try to import it.
  3. dillbeck

    Unresolvable DTS Error

    The table in question has four date-type fields: Start Date, Start Time, End Date, End Time. The data was created in Access, which has it's own formatting controls. Where data is found in these fields, it appears to be valid. Only the Start Date is a required field. The 26th row date data looks...
  4. dillbeck

    Unresolvable DTS Error

    I get the following error when running DTS for a specific table in an Access 97 database: "Error at Destination for Row 26. Errors encountered so far in this task: 1. Invalid character value for cast specification". When I look at row 26 in the Access table I see nothing wrong with...

Part and Inventory Search

Back
Top