Hi, I am doing a small application which will import data from an excel sheet and display it in a datagrid. I have done the coding for that part. i also want to store the excel sheet data in an access database. The column headings in excel sheet should be the field name in the access database. Can anyone help me with the coding for importing data from an excel sheet and storing in an access database.
The import function (on the File menu) should do the trick for you. If you specify that you're importing from an Excel spreadsheet, it will ask you if the first row contains the field names. There's also a way to set up a macro to import from Excel files by using the TransferSpreadsheet action, but I've never used it. Maybe that will be enough to point you in the right direction.