How can I create a access report from a existing excel format ?

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

Guest

At the moment I use a excel file to report some data. From now I want to
start using a access database, however I need to keep the same format that I
have in Excel. Is there any way of importing the excel file to produce the
report ? Or do I need to draw everything ?
 
Access does have the ability to import excel files into itself. However
Access should not be used as a spreadsheet that defeats the purpose of being
a database. You should either keep the excel file up to date and import when
you want to print your report. Or design an Access DB that can keep your file
in the correct format. There are plenty of websites that explain the
differences between a database and a spreadsheet. Read Them!

HTH
Martin
 
Also you can link the Excel file to the database and when you update Excel it
updates Access. Then you can use Access to creat reports
Sarah
 
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

Excell 2021 0
How can I choose which table should report show? 2
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Transfering an Access Report to Excel 1
report format can copy and paste 3
Access Report to Excel Worksheet 2
create a blank report 3
Exporting a report to Excel 1

Back
Top