Reports from linking

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

Guest

General question. Is it possible to link to an excell file ,import the data
and makes reports from this data?
 
You can link/import Excel data into Access tables. You can make reports from
these.
 
Thanks Duane,
I guess a better question would be to have my tables populated with the data
in the excell sheets and then report on this data. I would like to migrate
from excell usage to access without having to imput the data from excell into
access.I have multiple workbooks and migrateing the data would be much
easier....Can this be done?
 
Can the data from excell be imported into the tables of access or would i
have to type all the information directly into access. Is this option
available?
 
You can import or copy and paste a range from Excel into Access. One method
uses:
File->Get External Data->Import
 
Back
Top