Adding data from Excel sheet to Access database
 

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

Adding data from Excel sheet to Access database
 

Look here William
http://www.erlandsendata.no/english/...php?t=envbadac



--
Regards Ron de Bruin
http://www.rondebruin.nl


"William Francis" <William wrote in message
...
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

Adding data from Excel sheet to Access database
 

You can also link or import using wizards. on the access
menu barfile 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
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
.