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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Filtering subreports on main report 0
Call report from different database 5
Cross Tab Report Vs Dynamic coulmns 0
report exporting 1
Having problems linking Child/Master fields in Report 10
Auto report from DBs in 3 different sites 3
Reports that sift records from different tables 0
Access Access Report Works on One Machine but not Another 3

Back
Top