hey all.. thanks for all your help,

i managed to solve it using Data tables.!

😀

i've changed the connection string to:

conn = New SqlConnection("Data Source=C:\mydatabase.mdb;User Id=admin;Password=;")

There is no error but the excel data does not get inserted into the access database table.

the Message box shows: The file is imported!

however, when i check the Microsoft Access database, nothing gets imported.

da is - Dim da As OleDbDataAdapter = New OleDbDataAdapter()

daA is -...

The coding shows no error, however, the excel data does not get imported into the Microsoft Access database.

whats the coding to put an excel file data into a MS access table?

The table name would be "apciti"

The field names are... PMCO, PMLOC, PMIPMT, PMEPMT, PMEDOC, PMCURI, PYORPM, PYDATE,...

It's required as all the data must be saved into the database and from there, extracted out.

its like,

Step 1: A user selects an excel file

Step 2: The excel file is being imported in to the database

Step 3: The contents in the file is being extracted for...