What is the difference between Acess and Excell.

  • Thread starter Thread starter Linda
  • Start date Start date
L

Linda

In the Acess program you have workbooks, in excell you are the workbook. But
how do you put them together??? What is the relationship?? My brain is
fried!!!!!
 
No workbook in Access. There are datasheets which look something like
workbooks, but don't work like them at all. There really is no relationship
between them either.
 
You are mistaken, there is no object called a "workbook" in Access. There
are tables and queries that can be viewed in a "datasheet view" which
appears similar to a spreadsheet. You can link to an Excel workbook, if it
is arranged in columns and rows to contain data, to read (only, not update)
the data, or you can import a table from Excel or export a table or query to
an Excel spreadsheet. In Excel, you can have formulas in each cell, and
they can be different for every cell in the spreadsheet or workbook; Access
tables are for storing data.

Larry Linson
Microsoft Office Access MVP
 
Back
Top