By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,162 Members | 992 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,162 IT Pros & Developers. It's quick & easy.

updating tables from external links

P: n/a
I work for a company where I do quality assurance. We get a
spreadsheet every week of the curent employees where I work. What I
need to do is import this spreadsheet every week and update my
tables.
Access will not allow me to create good relationships between other
tables and the linked table. Also, if I import the table it works
fine; however, the second time I import into the same table it gives
me a non-descript error message.
Basically, I don't know anything about how to manage the linked data.
I also need to make sure that if data is deleted from the spreasheet
that it is _not_ deleted from our database. Employees may leave our
company but we still need to retain their records in our database. My
_main_ concern is: how do I get this linked data to tables that I can
actually work with and create relationships with. I'm just a noob with
Access so I'm probably missing some crucial but simple piece of
information. I'm bascally looking for information on how people
generally handle linked spreadsheets.
~James
Dec 11 '07 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On Tue, 11 Dec 2007 13:36:11 -0800 (PST), majortool
<ma*******@gmail.comwrote:

One of your requirements is:
I also need to make sure that if data is deleted from the spreasheet
that it is _not_ deleted from our database
Given that, it is not possible to use links to spreadsheets since
these spreadsheets can be modified without your app knowing about it.
The good part is that you don't need to know about linking.
Rather you would have to know about importing, and get on top of that
"non-descript" error. Post a new message with that error, and perhaps
we can make it a bit more descriptive to you.
OBVIOUSLY you cannot import the same data twice. That would
(hopefully) violate all kinds of unique indexes.

-Tom.
>I work for a company where I do quality assurance. We get a
spreadsheet every week of the curent employees where I work. What I
need to do is import this spreadsheet every week and update my
tables.
Access will not allow me to create good relationships between other
tables and the linked table. Also, if I import the table it works
fine; however, the second time I import into the same table it gives
me a non-descript error message.
Basically, I don't know anything about how to manage the linked data.
I also need to make sure that if data is deleted from the spreasheet
that it is _not_ deleted from our database. Employees may leave our
company but we still need to retain their records in our database. My
_main_ concern is: how do I get this linked data to tables that I can
actually work with and create relationships with. I'm just a noob with
Access so I'm probably missing some crucial but simple piece of
information. I'm bascally looking for information on how people
generally handle linked spreadsheets.
~James
Dec 12 '07 #2

P: n/a
I was hoping that it would update when I imported it again. Ninety
per cent of the employees will be the same. I'll need it to overwrite
data in the table or not even take duplicate data at all.
I was thinking: what if I could use an update query to update new
fields. I don't even know if that's possible let alone how to even
get started on that. I do know a bit about VBA. I'm gonna look into
manipulating linked sheets with VBA.
~James
Dec 12 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.