Exporting Data

  • Thread starter Thread starter Vince
  • Start date Start date
V

Vince

Hello, I was wondering if you can create a MACRO to export
data entered into a table into specific fields on an excel
spreadsheet? Could you set something up to automatically
update an excel file?
 
I have linked Excel files in my Access database and when
ever I make a change or add a record in Access it, real
time, changes the Excel file. Additionaly, if I change
anything in the Excel file it changes the Access table
real time. What you might do is, export your table to an
Excel file. Then link the new Excel file back in to your
Access DB. From there on out, use that table instead of
the table you are currently using.

Marty
 
Back
Top