Search : in
By :

Import excel to access

Last answer on May 8, 2009 9:09:15 am BST john_v, on Nov 20, 2008 11:03:15 am GMT 
 Report this message to moderators

Hello,
I would like some help about access cause i think i am going mad ;-)
Is it possible to link a specific cell in Access to another specific cell in Excel?
I have created a database in Access with my students' names and classes all these years and i want with double-clicking on someone's name, the correct excel file to be opened with the student's grades.
E.g: i have now 3 columms: John Markous, Monday 10.00-12.00, 2002-2003.
I want at least,with macros i suppose, to open the exact excel file where i have the John Markous' s grades
stored.

Thank you a lot!

Configuration: Windows XP
Firefox 3.0.3

Best answers for « Import excel to access » in :
Import contacts from Excel to Outlook Show Import contacts from Excel to Outlook Issue Solution Issue How to import a contact list from Excel to Outlook and having them in a single list of contact , and not as splited items? Solution By using the software Excel 2000 and...
Importing excel on access Show
Import web data into Excel Show
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel Below is a tips of how to connect an Access database (MDB) in an application excel Add reference Microsoft DAO object librairy X.X In a general module (eg Module1) paste the code below...
[VBA: VB6] Using excel from another application Show[VBA: VB6] Using excel from another application Here is a little routine to call Excel from VB6 or another Office application. Paste in a general module (eg Module1) In VBA>> Insert>> Module and paste in the window ... In VB6>>...
How to access your BIOS set up ShowHow to access your BIOS set up Depending on your computer model, the way you will access your BIOS set up menu will differ. Here is a list of the most common models used and the access key used for this process. ACER You can make use...
Download Office Key Show
Download Removable Media Undelete Tool ShowRemovable Media Undelete Tool is a data recovery utility to find Microsoft Office documents that you have removed accidentally or not. You can restore documents created with Word, Excel, Access or PowerPoint. It provides easy and step by step...
Download Pop-up Excel Calendar ShowNow, it is possible to avoid entering manually dates in Excel worksheets. With Pop-up Excel Calendar you can have access to date directly in your Excel worksheet. Pop-up Excel Calendar is an add-in for Microsoft Excel allowing to display a small...
Random access memory (RAM or PC memory) ShowTypes of random access memory There are generally two broad categories of random access memory: DRAM memories (Dynamic Random Access Module), which are inexpensive. They are used essentially for the computer's main memory SRAM memories (Static...
WPA - WiFi Protected Access ShowIntroduction to WPA WPA (WiFi protected Access) WiFi network security solution offered by the WiFi Alliance, in order to fill gaps in WEP. WPA - WiFi Protected Access WPA is a "light" version of the 802.11i protocol, which relies on...
Spreadsheets - The Excel Interface ShowExcel Introduction Microsoft Excel is the spreadsheet in the Microsoft Office office suite. To start it, simply click on the appropriate icon in the Start menu (in Windows) or click on an Excel file (that has an .xls file extension). A Excel...
Ask your question Reply

1

geesapitan, on Feb 27, 2009 11:40:08 am GMT
  • +28

Hi could someone tell e how to connect ms access with ms excel?i need it plsss....

   
Reply to geesapitan

2

tom, on Apr 6, 2009 6:25:25 am BST

Well, a round about sort of way of doing it would be to add another field to your student table that is an attachment type. Then you would have to include the particular Excel file as the attachment. This could be a little rough at first to enter it in, but at least you only have to do it once a year! :)

   
Reply to tom

3

varuns, on Apr 9, 2009 8:42:13 pm BST
  • +14

Hi There,

Can some one tell me how to use MS Access?

You can just tell me the name of the website.

Thanks in advance.

Regards,
Varun.

   
Reply to varuns

4

 imron ali, on May 8, 2009 9:09:15 am BST
  • +10

Thank 's so much i get download this file

   
Reply to imron ali
Ask your question Reply
They need your help