I have a database in Access 07 that I need to be portable/self-contained, however, it pulls a major peice of data from a database on our internal network as well as other data from linked Excel spreadsheets. My question is, is there an easy way to set my database up so that I can pull the data from the database into a table as needed (the data just needs to be refreshed about once a week or so) replacing the old data with the new? I would also like to do the same with the linked Excel spreadsheets. This would give me the ability to use my database as a stand-alone unit without having to be connected to the internal network or constantly copying updated spreadsheets.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.