Adding data from Excel sheet to Access database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Retrieve data from encrypted Access 1
Help with copying a sheet from One workbook to another workbook 1
Many to One (Excel sheet) 4
Efficient Excel to Access uploads 1
Passing data to an event handler 3
Auto Copy Data from one worksheet to another 1
macros to query a database 9

Back
Top