link table

[KimVong]

I am currently using excel as my database, and would like to change to access 2000,
In excel, you can link from one cell of a sheet to another cell in another sheet. In access, how can you link from one table cell to another? Please help.....
thanks

 

[mikey69]

Kimvong - you need to understand that Access works in a completely different way from Excel. You really need to get some sort of background reading to introduce you to relational database concepts. there are many books available. I could suggest some if you need help.

 

[cmmrfrds]

Use the UDL Wizard to find the computer and test the connection. If you can get this far the rest will be easy.

Here is how you invoke the udl wizard. Do this on your desktop.

1. create a blank notepad file.
2. save the file.
3. rename the file by adding a new extention of .udl
make sure you save as all files not txt or some other
file type.
4. the icon for the file should change from notepad to a
little computer - it has now become the wizard.
5. double click on the file and it will bring up a dialog
box with multipule tabs.
6. use the microsoft Access provider – this will be Jet 4.0 for Access 2000 or Jet 3.51 for Access 97.
7. look under the ALL tab and there will be parameter settings which you can change if necessary. There is a test
button, press to test the connection.
8. close the file.
9. open the file from notepad instead of double clicking the icon. You will see the connection string which you can copy and paste into your program.