Exporting data from an Access Table to Excel Cells XP

  • Thread starter Thread starter Connie Reed
  • Start date Start date
C

Connie Reed

Hi All:
I wonder if anyone could explain to me to how to export a
field from an Access table into an Excel Cell in a
spreadsheet.
I have 21 tables of fields and a huge spreadsheet to
populate with all these fields.
I am doing this from a button on a form in Access, so I
would need to use VBA to populate each cell in the
spreadsheet. Need help to get started.
I am downloading this data from a Stratus Text file over
the network via ftp into Access and then exporting it to
Excel. The access part assures a restore procedure should
the user lose the data. The part I don't know how to do is
the above export into Excel cells.
Thanks for you help in advance, it's a relief to be able
to ask someone who knows how to do this.
Thanks again, Connie
 
Hi Connie,

This is a useful article giving the basics of controlling Excel from
Access:
Sample Excel automation
http://www.mvps.org/access/modules/mdl0006.htm

The following Microsoft Knowledgebase articles are helpful too:
ACC: Sending the Current Record to Word 97 with Automation (Q131583)
http://support.microsoft.com/?id=131583

Q123859 ACC: Sample OLE Automation for MS Word and MS Excel
http://support.microsoft.com/?id=123859

ACC2000: Using Automation to Create and Manipulate an Excel Workbook
(Q210148) http://support.microsoft.com/?id=210148

ACC: Using Automation to Create and Manipulate an Excel Workbook
(Q142476)
http://support.microsoft.com/?id=142476


There's a white paper and code samples including tutorials available
from Microsoft at
http://support.microsoft.com/?id=253235

Also, search www.mvps.org/access for "automation excel"
 
Thank you John, I appreciate your answers greatly! It iwll
help me get a jump start on this massive project. You've
been so helpful!
-----Original Message-----
Hi Connie,

This is a useful article giving the basics of controlling Excel from
Access:
Sample Excel automation
http://www.mvps.org/access/modules/mdl0006.htm

The following Microsoft Knowledgebase articles are helpful too:
ACC: Sending the Current Record to Word 97 with Automation (Q131583)
http://support.microsoft.com/?id=131583

Q123859 ACC: Sample OLE Automation for MS Word and MS Excel
http://support.microsoft.com/?id=123859

ACC2000: Using Automation to Create and Manipulate an Excel Workbook
(Q210148) http://support.microsoft.com/?id=210148

ACC: Using Automation to Create and Manipulate an Excel Workbook
(Q142476)
http://support.microsoft.com/?id=142476


There's a white paper and code samples including tutorials available
from Microsoft at
http://support.microsoft.com/?id=253235

Also, search www.mvps.org/access for "automation excel"

Hi All:
I wonder if anyone could explain to me to how to export a
field from an Access table into an Excel Cell in a
spreadsheet.
I have 21 tables of fields and a huge spreadsheet to
populate with all these fields.
I am doing this from a button on a form in Access, so I
would need to use VBA to populate each cell in the
spreadsheet. Need help to get started.
I am downloading this data from a Stratus Text file over
the network via ftp into Access and then exporting it to
Excel. The access part assures a restore procedure should
the user lose the data. The part I don't know how to do is
the above export into Excel cells.
Thanks for you help in advance, it's a relief to be able
to ask someone who knows how to do this.
Thanks again, Connie
Click to expand...

--
John Nurick [Microsoft Access MVP]

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