want to get data from excel and insert it into database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

H

I have data in Excel file. Each line in Excel represents one row in table
I want to read row from Excel and insert it into table if data row is missing in the table. I want to update table if values in one or two columns are missing. And if data row is available in the table then I don’t want to do anything with that data row. Getting data from Excel into dataset is straight forward. But I don’t know how to update table

Thank you for any help

Smita
 
Once you have the data into a datatable, you can call update using the same
dataadapter that you are using for the table. You can just create another
dataset and use Merge, then call update.
SM said:
Hi

I have data in Excel file. Each line in Excel represents one row in table.
I want to read row from Excel and insert it into table if data row is
Click to expand...
missing in the table. I want to update table if values in one or two columns
are missing. And if data row is available in the table then I don't want to
do anything with that data row. Getting data from Excel into dataset is
straight forward. But I don't know how to update table.
 
¤ Hi
¤
¤ I have data in Excel file. Each line in Excel represents one row in table.
¤ I want to read row from Excel and insert it into table if data row is missing in the table. I want to update table if values in one or two columns are missing. And if data row is available in the table then I don’t want to do anything with that data row. Getting data from Excel into dataset is straight forward. But I don’t know how to update table.
¤

You may want to identify what kind of database you want to insert the Excel row into.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)
 
Back
Top