How can I (if at all possible) export a certain numer of cells, lets say the first row on a sheet to an existing access database, adding the data to an existing table, even allowing to assume that the columns on the sheet match the columns in the existing database.
To explain. I have a database with employee numbers ,contract numbers, 2 dates, a month, a year and a boolean.
I receive about 200 excel forms a month to process after which i have to add the above data, which is found on the form or input bij me, to the database. I would like to be able to do this in VBA by simply pressing a button. The button is not a problem, but does excel allow me to open an access database for write and add the data to the existing table. Furthermore, can this be done multiuser?
Luke
To explain. I have a database with employee numbers ,contract numbers, 2 dates, a month, a year and a boolean.
I receive about 200 excel forms a month to process after which i have to add the above data, which is found on the form or input bij me, to the database. I would like to be able to do this in VBA by simply pressing a button. The button is not a problem, but does excel allow me to open an access database for write and add the data to the existing table. Furthermore, can this be done multiuser?
Luke
