Access to Excel merge

  • Thread starter Thread starter Serghei
  • Start date Start date
S

Serghei

Hi everyone,

does anyone know how to merge(link)a field from a table in
Access database to Excel (similar Word mail merge).
I need to have a table field linked to a cell in Excel.

Thank you,

Serghei
 
Hi Serghei,

There are several possibilities. One is to create a query in Access that
returns just the data you need; then in Excel use Data|Import External
Data. If you give more information about just what you are trying to
achieve we may be able to offer more specific help.
 
Hi John,

the result I am trying to achieve is similar to mail merge
in Word, but use it in Excel. Where cells will reference
(have links) to a table fields in Access database...
Say to print an invoice based on data in Access.

Sergei
-----Original Message-----
Hi Serghei,

There are several possibilities. One is to create a query in Access that
returns just the data you need; then in Excel use Data|Import External
Data. If you give more information about just what you are trying to
achieve we may be able to offer more specific help.

Hi everyone,

does anyone know how to merge(link)a field from a table in
Access database to Excel (similar Word mail merge).
I need to have a table field linked to a cell in Excel.

Thank you,

Serghei
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
 
Hi Serghei,

I don't think there's an exact equivalent to Word's Mailmerge. I'd start
with the method I suggested: use Data|Import External Data to import an
Access query. To automate it, record a macro and then modify the code
generated by the macro.

If you're working in Excel and extracting data from Access, it's
probably better to think of this as an Excel problem and ask for help in
an Excel group.

Hi John,

the result I am trying to achieve is similar to mail merge
in Word, but use it in Excel. Where cells will reference
(have links) to a table fields in Access database...
Say to print an invoice based on data in Access.

Sergei
-----Original Message-----
Hi Serghei,

There are several possibilities. One is to create a query in Access that
returns just the data you need; then in Excel use Data|Import External
Data. If you give more information about just what you are trying to
achieve we may be able to offer more specific help.

Hi everyone,

does anyone know how to merge(link)a field from a table in
Access database to Excel (similar Word mail merge).
I need to have a table field linked to a cell in Excel.

Thank you,

Serghei
Click to expand...

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.
Click to expand...
Click to expand...
 
Back
Top