Import Button in MS Access

[amunafc]

Import Excel into Access database

Guruz

I have attached a copy of a database. I want when a button is clicked, it should automatically import an excel file I have attached. thanks

 

[vbaInet]

Look into this DoCmd.TransferSpreadsheet

 

[amunafc]

ok lemme do it now, thanks many times

 

[vbaInet]

You're welcome. Don't forget to look in the VBA help files for a full explanation and if you get stuck too, there are lots of examples on the forum so do a search.

 

[amunafc]

Again many thanx and I think I am winning

 

[vbaInet]

Good to hear Win win win!!!

 

[amunafc]

winning winning

 

[gemma-the-husky]

out of interest - if you have a csv INSTEAD of a spreadsheet - you will find you actually have more control over the import.