Access Report

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

Hi,
All my data is in Excel, but can I display it using an access report that I
create via vba in Excel?
Many thanks,
Dan
 
You can open an excel workbook using an Access Application using an ADO/DBO
Open statement. You'll be addressing the excel data like a table in Access
by going to the correct row and then getting the correct Column in the table.

The Microsoft office Structure of an Excel worksheet and an Access tabgle
are really the same. There is only some problems in Access with diffeerent
versions of Access.
 

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

Using ADO to get the first 5 fields horizontaly 4
Automatic replace of VBA code for multiple files 4
Access Print Files from Query Results 0
Automating producing PDF of my Excel reports 1
Why do charts disappear? 2
Currency formatting (Issue with globalization/localization) 2
PDF the Excel Report 3
Create Word (or Excel) Reports via VBA 1

Back
Top