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.
 
Back
Top