Access to Excel to Word question

[muneca]

Using VBA I want to export a table from Access to Excel and then open a Word
template and import the table from Excel to the end of a Word template. I
want to do all of this from within Access. Is this possible? Is there a
better way?

 

[Jeff Boyce]

Why to Excel first? Why not directly from Access to Word?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[a a r o n _ k e m p f]

I'd guess that he's trying to get some sort of decent formatting.

And if you want decent formatting from Access to Word, then you need
to use SQL Server Reportign Services 2008
And if you want decent formatting from Access to Word, then you need
to use SQL Server Reportign Services 2008
And if you want decent formatting from Access to Word, then you need
to use SQL Server Reportign Services 2008
And if you want decent formatting from Access to Word, then you need
to use SQL Server Reportign Services 2008
And if you want decent formatting from Access to Word, then you need
to use SQL Server Reportign Services 2008
And if you want decent formatting from Access to Word, then you need
to use SQL Server Reportign Services 2008

 

[Euclid]

Yes, it's a matter of formatting preference. The customer seems to like the
cells that Excel provides. I don't know anything about "SQL Server Reporting
Services 2008" and, even if I did, the company I work for does not have that
software.

 

[Jeff Boyce]

I did not see the reply by aaron-kempf. Perhaps it was deleted from the
newsgroup.

Mr. Kempf has repeatedly answered "SQL-Server" to just about every question
posed in these Access-oriented newsgroups. If you search a bit, you'll find
that his responses and manner are the subject of frequent criticism.

As always, take whatever advice you receive here in the newsgroups with some
question...

If the eventual end-point is Word, Word offers perhaps even more formatting
options than Excel.

Good luck.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[a a r o n _ k e m p f]

SQL Server Reporting Services is basically-- for all purposes--
_FREE_.

So sorry that you don't understand the benefits of moving from a free
database with no future-- to the worlds most popular database (in a
format that is free).

You should learn more about SQL Server before jumping to any
conclusions.
Basically- Jet sucks. SQL Server can solve world hunger.

-Aaron

 

[a a r o n _ k e m p f]

Jeff;

I see that Microsoft Jet databases frequently corrupt.

Maybe you should be lighting fires under that incompetent company (get
them to fix Access bugs that are a decade old)- instead of trying to
tell me that I'm wrong

-Aaron

 

[Jeff Boyce]

?! let them eat code ?! <g>

Jeff

SQL Server Reporting Services is basically-- for all purposes--
_FREE_.

So sorry that you don't understand the benefits of moving from a free
database with no future-- to the worlds most popular database (in a
format that is free).

You should learn more about SQL Server before jumping to any
conclusions.
Basically- Jet sucks. SQL Server can solve world hunger.

-Aaron

 

[James A. Fortune]

Jeff;

I see that Microsoft Jet databases frequently corrupt.

Maybe you should be lighting fires under that incompetent company (get
them to fix Access bugs that are a decade old)- instead of trying to
tell me that I'm wrong

-Aaron

You call Microsoft incompetent because of JET (and I suppose they are),
but then recommend another product by the same incompetent company .

Although I can see that happening (for instance, New York City was
simultaneously voted the best place to live and the worst place to live
recently), I prefer to think that Microsoft is actually capable of being
competent and that many of JET's weaknesses and flaws are left in by
design. It still amazes me and amuses me to think that the company with
the world's record for software bugs has the audacity to offer software
certification .

So should I buy SQL Server because Microsoft forces me to by keeping in
as many bugs in JET as they can get away with? The bug wave paradigm is
flawed . Without open source software such as MySQL, would Microsoft
even have an Express version of SQL Server? Why should we put up with a
company with both heels dragging in the dirt instead of choosing some of
the software that forced them to make free happen? I think we know the
answer to those questions. I choose to believe that SQL Server has the
quality it has because it has the kind of competition in the marketplace
that JET lacks. In spite of all that, SQL Server can be a little too
over-the-top (one book suggests that the etymology is from the days of
trench warfare) for most modest needs.

James A. Fortune
(e-mail address removed)

 

[a a r o n _ k e m p f]

Microsoft doesn't take Jet seriously-- because they own a real
database-- and because they're putting tens of billions of dollars
into SQL Server and _NOTHING_ into the future of Jet

SQL Server rocks.
Jet doesn't support a single user and 25mb of data.

It's not that Microsoft is ****ed.
Jet is ****ed, as is anyone that uses it for anything.

-Aaron