I need to transfer a database file from access to Excel and hten do a mail
merge

You can get the contents of any table imported into an Excel worksheet a
couple of ways.

From Excel, choose
Data | Import External Data | Import Data
Then browse to the .mdb file and identify it and choose from the tables
displayed.

From Access you can open a table or query and then choose File | Export and
choose the .xls file type. An Excel workbook with a single sheet will be
created. Both the workbook and the worksheet will have the name of the table.

Eventually you'll end up over in Word and during the Mail Merge process,
just identify the Excel workbook as your data source.

"Jan" wrote:

I need to transfer a database file from access to Excel and hten do a mail
merge

I would suggest you do the mailmerge in Word.

You can use the Access DB as source.

No need to involve Excel if you don't want to.

If you do want to use Excel, see JLatham's post.

For help on Word mail merge using Excel or Access as the data source.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm


Gord Dibben MS Excel MVP



On Fri, 7 Jul 2006 07:52:02 -0700, Jan wrote:

I need to transfer a database file from access to Excel and hten do a mail
merge

Gord Dibben MS Excel MVP

One more potential source for information on setting up in Word to use Excel
as a Mail Merge data souce is an Excel workbook with step by step
instructions that I prepared to assist another person with such a request
elsewhere recently. That document can be found at
http://www.jlathamsite.com/Teach/Wor...DataSource.xls

if you feel the quality is good enough, feel free to provide links to it
anytime.

"Gord Dibben" wrote:

I would suggest you do the mailmerge in Word.

You can use the Access DB as source.

No need to involve Excel if you don't want to.

If you do want to use Excel, see JLatham's post.

For help on Word mail merge using Excel or Access as the data source.

http://www.mvps.org/dmcritchie/excel/mailmerg.htm

http://www.mvps.org/word/FAQs/MailMe...AMailMerge.htm

http://www.mvps.org/word/FAQs/MailMe...DataSource.htm


Gord Dibben MS Excel MVP



On Fri, 7 Jul 2006 07:52:02 -0700, Jan wrote:

I need to transfer a database file from access to Excel and hten do a mail
merge

Gord Dibben MS Excel MVP