Excel spreadsheets linked to tables in Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How can I, if possible, link an Excel spreadsheet to an Access table; and
have the capability of multiple users accessing the data, via a report, which
is a function of the linked spreadsheet? Is there a piece of VBA code that I
can apply?

Currently, a report, which is a function of a linked table, can only be
viewed by one user at a time.

I would appreaciate any feedback on this issue.

Thank You,
Tony Catalano
 
There are a couple of ways to do this. You can use COM interop to create a
spreadsheet. You can use the VSTO office subsystem, or you can use the
Office Web Components.

--
Regards,
Alvin Bruney - ASP.NET MVP

[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
Now available @ www.lulu.com/owc
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Linked Excel spreadsheet to be used as table 3
Data Type Issue in Linked Excel Table 7
Access to Excel link 2
access / excel link 4
linking to an Excel spreadsheet 1
A2003 bringing in data from an Excel spreadsheet 1
Importing excel spreadsheet into multiple Access Tables. 4

Back
Top