Appending Excel Files to Access

  • Thread starter Thread starter vivi
  • Start date Start date
V

vivi

Hi I am currently learning to use Access for my work and have been reading a
few books to learn the basis functions. However, I am trying to get someone
to help me with VBA...

I am hoping to append data to a table from excel automaically, I have
successfuly sort out what i need in Excel but there are about 20 files all
together in their specific location (as they all have different formats). I
was thinking to have as set of 20 control tables on access and each month
when the files are changed, then i can append the new set of data to the
control table. I hope this make sense...

Can someone teach me what I need to do please? or point me to a place to
learn though the VBA codes are very confusing and not very familiar with
them...I am learning to use VBA codes on both Excel and Access, can somebody
also direct me to a good and easy to follow book so i can learn the codes
please ???

Thanks a lot :)
 
You can link from Access to Excel. That will create what look like tables
that you can then use in an Append query.

In fact, if you want to go one step further, and not only append new
records, but make sure that nothing changed in any of the existing records,
see my November, 2003 "Access Answers" column in Pinnacle Publication's
"Smart Access". You can download the column (and sample database) for free
from http://www.accessmvp.com/DJSteele/SmartAccess.html
 
Back
Top