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