Adding data from Excel sheet to Access database

W

William Francis

Hi

I am a bit of a novice where Access is concerned. Am I able to write some VBA code which will add information entered into an Excel sheet into an Access database?

Any examples would be greatly appreciated.

Thanks
William
 
F

Frank Stone

You can also link or import using wizards. on the access
menu bar>file > Get external Date > Import OR Link. follow
the wizard instructions. Linked xl files can be used as
tables in access queries.
-----Original Message-----
Hi

I am a bit of a novice where Access is concerned. Am I
Click to expand...
able to write some VBA code which will add information
entered into an Excel sheet into an Access database?
 
Top