Exporting MS Access to Ms Excel with Excel formatting

[TJVFree]

I’ve read a lot of different article on the internet about being able to export a table from MS Access to Ms Excel.

Problem I’m having is that I don’t know which one would work best for me, so I thought since I’ve gotten such great advice from this form I will ask.

I have a query that updates a table in access.
What I would like to have happen in the export from access to excel

Currently I have a number of queries that updates number of table daily.
Then I manual export the tables to a excel files
Then I spend 15 -20 minutes formatting the excel fine. “I format all the table to excel files that same way.
Once this is done I email it out in excel format to different managers that need to make commits and then email the spread sheet back to me then I import the spread sheets and record there comments.

If at all possible I would like all the files to import into one spread sheet just into different tabs. I have a bout 4 different group.

Below are some of the articles I’ve read about exporting from access to excel.

Looking for any advice example ect

http://www.databasejournal.com/features/msaccess/article.php/3563671/Export-Data-To-Excel.htm

http://www.vb123.com/toolshed/98docs/excelbe.htm

http://www.tek-tips.com/viewthread.cfm?qid=1201057

http://zmey.1977.ru/Access_To_Excel.htm

http://www.databaselessons.com/access-data-to-excel-2.php

Thanks for all your help and advice
TCB

 

[SkipVought]

Hi,

I would do it ALL in Excel, where you can format to your liking, ONE TIME.

Use MS Query to execute the MS Access queries and return one to each sheet.

They can all be automatically refreshed on Open, or you can refresh them from Access via code.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[TJVFree]

Thanks Skip, is there a way you can show me more of an example. The way you described it sounds the least complicated

Thanks
TCB

 

[SkipVought]

What version Excel?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[TJVFree]

Office Excel 2003 SP3

 

[SkipVought]

On any sheet...
[tt]
Data > Get external data > New database query --

In the Choose data sources window, UNCHECK 'Use the query wizard...'

Select MS Access files

Drill down to your db.

Add your table/query to the QBE grid (similar to MS Access)

Pull down your fields.

Add any criteria as required.

File > Return data to Microsift Excel.
[/tt]
That's a start.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[TJVFree]

I have a query that updates a table in access.
What I would like to have happen in the export from access to excel and have it properly formatted in excel.

Currently I have a number of queries that updates number of table daily.
Then I manual export the tables to a excel files
Then I spend 15 -20 minutes formatting the excel fine. "I format all the table to excel files that same way.
Once this is done I email it out in excel format to different managers that need to make commits and then email the spread sheet back to me then I import the spread sheets and record there comments.

If at all possible I would like all the files to import into one spread sheet just into different tabs. I have a bout 4 different group.

 

[SkipVought]

Did you try doing what I outlined above?

You only have to do that ONE TIME!

After that it's just a REFRESH!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[TJVFree]

Not yet, but I will try that first. Thanks Skip

 

[TJVFree]

Cool, thanks Skip. I did the same thing for one of my table in my database but didn’t think of doing it this was also.

Thanks again
TCB

 

[SkipVought]

Wonderful!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}