Help in excel to access database connectivity

[lokeshsu]

Hi All,

i have an excel file which i want to connect to access database. i have values in a series of cell when i click a button the data should go and paste in access. need help please help me

Lokesh

[gnawoncents]

Is this a one-time operation or recurring process? There are several ways to accomplish this, some better than others depending on what you need to get done.

If the fields remain stable in the Excel file, you could simply link to it and it will act like any other linked table.

You could link to it and use a make table, update, or append query to copy the data over to a table residing in your database.

With more information we can help point you in the right direction.