Results 1 to 3 of 3

Thread: Data type conversion error

  1. Jan 30th, 2003, 08:39 AM #1
    SpiderByte
    SpiderByte is offline

    Thread Starter
    New Member
    Join Date
    Jun 2002
    Location
    West Australia
    Posts
    9

    Data type conversion error

    I have been able to export records from a database using an OleDb.OleDbConnection, writing to a text file and then converting it to an MS Excel format file. Then I am able to import all the data from the Excel file back into a Dataset or DataTable successfully. The problem is I cannot save it back to the original table as the Integer fileds have been converted to doubles namely the auto increment field and a couple of others. I get a datatype conversion error. Is there any succesful way of doing an export/import routine from a database to MS Excel?
    Your help would be appreciated greatly. Cheers!!
    Reply With Quote Reply With Quote
  2. Jan 30th, 2003, 01:55 PM #2
    MrGTI
    MrGTI is offline
    Frenzied Member MrGTI's Avatar
    Join Date
    Oct 2000
    Location
    Ontario, Canada
    Posts
    1,277

    Thumbs up

    Easy way is with "Import and Export Data", otherwise known as DTS. It's installed with SS2K.
    ~Peter

    Reply With Quote Reply With Quote
  3. Jan 30th, 2003, 02:04 PM #3
    Pirate
    Pirate is offline
    Sleep mode
    Join Date
    Aug 2002
    Location
    RUH
    Posts
    8,083
    maybe this helps ?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width