export data from access into multiple spreadsheets

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

Guest

Hi, I have a prolem with creating only one function to export the three
access tables into three sheets of one excel file. Can we do this by the
function of "transferspreadsheet".
 
What version of Access?
If you are at least 2000, you may get away with something the the Help file
says you can't do. The TransferSpreadsheet has an argument for a range. It
states
that if you enter a range for an export, it will fail. I have not done it
myself, but I have seen some posts that say it will work. So you function
will have 3 Transferspreadsheets, each with the same file name, but different
query names and different range names.
 
Back
Top