Updating Access with New Excel Data

  • Thread starter Thread starter KD
  • Start date Start date
K

KD

I used to do a lot in Access so I'm familiar with building the database,
forms, tables, relationships, switchboard, etc. but haven't done much Access
work recently.
I'm now trying to build a new Access databse/utility that will have the
reports I'd like to see created. The Excel data is downloaded from another
system and always the same - the fields are the same, it's only the number of
records that differs.
What's my best way for importing these files? Is there an easy way to
copy/paste the data into Access (always paste to the same place) and then run
the reports? I want to avoid linking if possible because the files will have
different names, so I'd have to continually change links. I'm trying to come
up with a utility to help my employees analyze continuously changing data,
but be able to generate reports with some standardization. I think I'll be
happier with results out of Access because of the ability to add the GUI
through the switchboard and make it easy for them to use, but I need an easy
way to import the data.
 
See VBA Help on TransferSpreadsheet
It is the method used to import Excel spreadsheet data in to Access.
Post back if you have more questions about it.
 
Hey, what is VBA? And is it complecated becasue I want to copy and paste data
from some excell spreadsheets to one of my Access databases. Basically to
save on time (Don't want to sit and type out each individual peice of data!)
Im a learner so layman's terms would be delightful!

Thank you in advance.
Emma
 
VBA stands for Visual Basic for Applications. It is the programming language
used in Access and other Microsoft Office applications.
It isn't that hard, but there is a learning curve. It may be better in the
beginning to use a Macro.
 
Back
Top