Data import to excel

  • Thread starter Thread starter pritesh01
  • Start date Start date
P

pritesh01

I have an access database...
With lots of financial information, its very easy to do some reports in
access...
But there are other stuff i need in excel, but when i import reports
from acces into excel, the format is lost, the reports have to be
reformatted.

How would i go about getting information into excel from access, so i
can manipulate it. using SQL.
I guess im asking how do i connect to the access DB, run queries, stuff
like that.
 
Excel has an Import External Data command on the Data menu. Or you can
export a query from Access to Excel using File|Export.
 
Back
Top