Upload Excel file to Access DB

shaheen · #1 (**permalink**) 11-15-08, 08:36

Hi all

Is anybody who can help me out in the titled situation, as i want to upload an excel file to an access database i want to write a code on a command button, which should allow me to append the same table without the duplication.

I am in great need to finish this project but i am hanging at the above situation.

Thanks in advance

healdem · #2 (**permalink**) 11-15-08, 10:12

have a look at the import wizard in Access
then do a macro to do the samethign, examine the macro and you should be gettign close to where you want to be,

myle · #3 (**permalink**) 11-15-08, 15:30

one tick i do is link the excel file then round a make query or a append query depending on what you want to do.

Internet Services

Web Development

Digital Marketing

Consumer Tech