Go Back   Access World Forums > Apps and Windows > Excel

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 11-19-2012, 04:48 AM   #1
Twilkes
Newly Registered User
 
Join Date: Jun 2009
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Twilkes is on a distinguished road
Linking vs importing an Excel table

I have a number of Excel worksheets to keep some basic data in, mainly because it's just easier and nicer to maintain data in Excel rather than going into Access tables, I use the filter/sort/formulas of Excel to maintain it, and also because there are people who will have to edit it that aren't familiar with Access.

At the moment I've been linking to these worksheets as that seems to be the simplest way, and any changes made in Excel are automatically reflected in the queries Access is running. But some of my queries are very slow, which I'm thinking is down to the linking, as I don't think it's possible to index linked tables and Access is constantly having to go out and fetch the data.

When generally is it best to import an Excel sheet, rather than linking to it? And if I did that, how would I make sure I always had the latest version available to Access?

Thanks,

Twilkes is offline   Reply With Quote
Old 11-20-2012, 09:44 AM   #2
MarkK
Super Moderator
 
MarkK's Avatar
 
Join Date: Mar 2004
Location: Vancouver BC
Posts: 7,761
Thanks: 10
Thanked 1,289 Times in 1,227 Posts
MarkK is a name known to all MarkK is a name known to all MarkK is a name known to all MarkK is a name known to all MarkK is a name known to all MarkK is a name known to all
What you want to avoid is having multiple copies or visions of the same data, since in that case you need to keep track of which version or copy is authoritative.
I believe you will find that as the size and complexity of your data grows, then Access is "easier and nicer."
__________________
formerly known as lagbolt | Windows 10 | Access 2010 | Visual Studio 2013 | "Institutions have a vested interest in perpetuating the problems to which they are the solution." - Clay Shirky
MarkK is offline   Reply With Quote
Reply

Tags
access , excel , import , link , performance

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing from Excel into table HV_L Modules & VBA 5 06-16-2011 12:57 AM
Linking Excel Table marino72 Queries 2 08-18-2008 06:52 AM
Importing Excel to Table Bsando Modules & VBA 1 08-04-2008 04:29 PM
append importing Excel table into access table? tenchy Tables 2 06-06-2007 01:54 AM
Linking Excel file to a table, instead of importing it brunces Modules & VBA 4 03-15-2007 08:12 PM




All times are GMT -8. The time now is 01:26 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World