Data import to excel

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.
 
J

John Nurick

Excel has an Import External Data command on the Data menu. Or you can
export a query from Access to Excel using File|Export.
 

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

Import data and update changed information 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Import from excel and add to table 11
Importing data from Excel into an existing Access table? 1
Import from Excel with some bad dates causes no records to import 1
Import EXCEL data with a different data type 1
Import data from ODBC 1
Import data from web 1

Top