Data type conversion error

[spiderbyte]

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!!

[Jym]

Why don't you just change them back to Integers before you save them ?

[eileen]

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