Exporting from access to excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi, I have a worksheet in excel that is a purchase order. I need to plug in
contact information from access into that worksheet. They are wanting some
sort of drop box or something of that sort. I need help...
 
Unfortunatly, you can no long update an excel spreadsheet linked as a table.
There are two options.
One would be to use com and write VBA code that would update the vaules in
the spreadsheet.
The other would be to write an Excel macro (VBA) that would attach to the
Access database and retrieve the information.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Export data to access from files in excel 1
How to Export Gmail Emails to PST Format? 4
Export to Excel - Replace a Range 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Exporting data in Access fields to cells in Excel 4
Exporting to Excel 1
Exporting Data to One Excel Workbook to Several Worksheets 2

Back
Top