What is the difference between Acess and Excell.

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!!!!!
 
A

Arvin Meyer [MVP]

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.
 
L

Larry Linson

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
 
Top