CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. January 30th, 2003, 08:18 AM #1
    spiderbyte
    spiderbyte is offline Junior Member
    Join Date
    Jan 2003
    Location
    West Australia
    Posts
    7

    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. January 30th, 2003, 12:13 PM #2
    Jym
    Jym is offline Member
    Join Date
    May 2002
    Location
    Toronto
    Posts
    167
    Why don't you just change them back to Integers before you save them ?
    Reply With Quote Reply With Quote
  3. May 18th, 2006, 11:44 PM #3
    eileen
    eileen is offline Junior Member
    Join Date
    Nov 2005
    Posts
    11

    Re: Data type conversion error

    Hi Spiderbyte,

    Can I have the vb.net script which export records from a database using an OleDb.OleDbConnection, writing to a text file.

    Thank you.

    Regards,
    Eileen
    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

Featured