(Msg. 9) Posted: Thu Aug 14, 2008 4:37 pm
Post subject: Re: Linked table question [Login to view extended thread Info.] Archived from groups: microsoft>public>access>tablesdbdesign (more info?)
Jeff,
I believe Microsoft lost a lawsuit a few years ago and as a result if you
installed the latest service pack, you can no longer link to Excel data. You
still can import Excel data. If you did not install the service pack, you
can still link to Excel as you said.
Steve
"Jeff Boyce" <nonsense.DeleteThis@nonsense.com> wrote in message
news:u1Cz7mk$IHA.984@TK2MSFTNGP06.phx.gbl...
> I'm not aware of any "triggers" built into Excel that would "push" a new
> record (or changes to existing records) over into an Access table.
>
> But if the data is being kept in Excel, I believe you can still "link" to
> that data. So why would you need to keep a copy in Access? Is there
> another business requirement you didn't mention.
>
> And if you do have a business need to store a copy of the same data in
> both Excel and in Access, and are looking for a mechanism that can help
> you keep these in sync, consider writing a routine that you include as
> part of the start-up for the Access application. While this won't be
> "real-time" and won't accommodate a change during normal business hours
> (unless someone exits the Access app and restarts it), it would refresh
> the data each time the app is launched.
>
> ... not that I'm suggesting that! Again, if the data is being maintained
> in Excel, why not just "link" to it?
>
>
> Regards
>
> Jeff Boyce
> Microsoft Office/Access MVP
>
>
> "Golfinray" <Golfinray.DeleteThis@discussions.microsoft.com> wrote in message
> news:CD18616D-7614-4ED6-9639-50ACA8FD40C5@microsoft.com...
>>I have a split database, BE on a LAN, each user has FE on machine. Some of
>>my
>> tables need to be periodically updated from Excel spreadsheets. Some need
>> to
>> be updated often. What is the best way to do that? I understand that now
>> Excel can no longer be directly linked to Access files? Is it possible to
>> have "live" tables that automatically update when a spreadsheet is
>> changed?
>> Or what is the best solution? Thanks a bunch!!!!
>
>
(Msg. 10) Posted: Thu Aug 14, 2008 5:45 pm
Post subject: Re: Linked table question [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Thu, 14 Aug 2008 16:37:33 -0400, "Steve" <nonsense.RemoveThis@nomsense.com> wrote:
>Jeff,
>
>I believe Microsoft lost a lawsuit a few years ago and as a result if you
>installed the latest service pack, you can no longer link to Excel data.
Your understanding is only partially correct. The lawsuit required MS to
remove the ability to *UPDATE* a linked Excel spreadsheet. You can still link
to the spreadsheet, it's just read-only.
--
(Msg. 11) Posted: Thu Aug 14, 2008 5:47 pm
Post subject: Re: Linked table question [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Thu, 14 Aug 2008 13:40:05 -0700, Golfinray
<Golfinray.RemoveThis@discussions.microsoft.com> wrote:
>I have the Excel files linked. Can I directly write queries, forms, and
>reports off the Excel data? What I did was take that data and put it into
>Access tables so that I could normalize it, break it up into the right
>tables, and then build my queries, forms, and reports, use code and so
>forth. I wouldn't be able to do that directly off the spreadsheets would I?
Only if the structure of the spreadsheets is the same as that of the
normalized tables. If the spreadsheets are typically "spreadsheety" you would
need to rerun the import and normalization process to keep in synch.
--
(Msg. 12) Posted: Sun Aug 17, 2008 8:39 pm
Post subject: Re: Linked table question [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Changing the subject slightly, the lawsuit required MS to
*PAY* for the ability to update a linked Excel spreadsheet.
MS *REMOVED* the ability because that was cheaper.
(david)
"John W. Vinson" <jvinson.DeleteThis@STOP_SPAM.WysardOfInfo.com> wrote in message
news:rrg9a491oc8nbf3u0rlmu1vmq0qd7e3ald@4ax.com...
> On Thu, 14 Aug 2008 16:37:33 -0400, "Steve" <nonsense.DeleteThis@nomsense.com> wrote:
>
> >Jeff,
> >
> >I believe Microsoft lost a lawsuit a few years ago and as a result if you
> >installed the latest service pack, you can no longer link to Excel data.
>
> Your understanding is only partially correct. The lawsuit required MS to
> remove the ability to *UPDATE* a linked Excel spreadsheet. You can still
link
> to the spreadsheet, it's just read-only.
> --
>
> John W. Vinson [MVP]
(Msg. 13) Posted: Mon Oct 19, 2009 12:29 pm
Post subject: Re: auto Refresh Linked spreadsheet discussion [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
Not sure if anyone will see this request for clarification because the topic
is quite old. If you do however see it, can you just confirm that what I'm
hearing is that currently there is no way to have the Access DB linked SS be
refreshed upon opening?
I have a linked SS and I have to go into the link manager to have it
refresh. I'm wondering if there's not a preference item somewhere that would
tell it "upon opening the Access DB , go grab all the new data in the SS.
(There is no edits, deletions etc on the DB side. It simply uses the SS for
the data)
Thanks if you can verify.
--
Rocky''''''''s Curious Coding
"John W. Vinson" wrote:
> On Thu, 14 Aug 2008 10:19:00 -0700, Golfinray
> <Golfinray.DeleteThis@discussions.microsoft.com> wrote:
>
> >I have a split database, BE on a LAN, each user has FE on machine. Some of my
> >tables need to be periodically updated from Excel spreadsheets. Some need to
> >be updated often. What is the best way to do that? I understand that now
> >Excel can no longer be directly linked to Access files? Is it possible to
> >have "live" tables that automatically update when a spreadsheet is changed?
> >Or what is the best solution? Thanks a bunch!!!!
>
> Just to clarify a possible misconception... what's been lost is the ability to
> *UPDATE* a linked Excel spreadsheet from Access. You can still use File... Get
> External Data... Link to create a link to a spreadsheet, which will work (in
> most respects) as if it were an Access table; you just can't update the data.
>
> You also cannot Index the linked table, or enforce referential integrity
> between it and any other table - so this may not meet your needs.
> --
>
> John W. Vinson [MVP]
>
All times are: Eastern Time (US & Canada) (change) Goto page Previous1, 2
Page 2 of 2
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other