Just Wondering

  • Thread starter Thread starter Golfinray
  • Start date Start date
G

Golfinray

I have a table that came from an excel spreadsheet. I then query that table
and have a report based on that query that is used by people in my office.
That original Excel spreadsheet is occasionaly updated. I know that every
time it is updated I could just go and add the additional information to my
table but I was wondering if there is a way to automate that. Thanks so
much!!
 
Hi:

Instead of creating the table in access, is there any reason why you can not
link directly to the Excel spreadsheet?
That way, you will always have the up to date data.

From the database window, choose File, Get External Data, Link Tables.

The nice thing about linking in Access is that it works in both directions.
If you change or add data in Access it shows up in Excel too.
The disadvantage is that you can not change any of the "table" properties
because the data resides in Excel.
 
The nice thing about linking in Access is that it works in both directions.
If you change or add data in Access it shows up in Excel too.
Click to expand...

Unfortunately, that used to be the case but is no longer. Microsoft lost a
lawsuit and were obliged to remove the feature that let Access update linked
spreadsheets.

Otherwise, right on the money.

John W. Vinson [MVP]
 
Wow, I had not heard about that.

Is this an update that will be pushed through in Office Service Packs? Does
it apply to all versions of Access?

CJ
 
Unfortunately, that used to be the case but is no longer.
Microsoft lost a lawsuit and were obliged to remove the feature
that let Access update linked spreadsheets.

Otherwise, right on the money.
Click to expand...

I think that they paid the Eolas license fee and may have restored
that feature in the latest service packs. I'm pretty sure I read
that somewhere, and that some service pack for something or other
was restoring direct linking. But I can't find anything to prove it.
 
I recently installed Microsoft Office 2004 on my new MacBookPro. I just
noticed that all emails I send are shown as coming from "Office 2004 Test
Driver" followed by my email address in parentheses. How can I remove this
reference and simply have my email address?
Richard Lutringer
 
I recently installed Microsoft Office 2004 on my new MacBookPro. I just
noticed that all emails I send are shown as coming from "Office 2004 Test
Driver" followed by my email address in parentheses. How can I remove this
reference and simply have my email address?
Richard Lutringer
Click to expand...

I'd suggest reposting this question in a Mac Office Outlook newsgroup. This
group is for the (Windows only) database software Microsoft Access.

John W. Vinson [MVP]
 
Back
Top