exporting spreadsheet

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

Guest

Hi
I'm trying a very simple (I thought) export to excel. Here's my code:
DoCmd.TransferSpreadsheet acExport, , "TestTable", "D:\Roxanne\Test.xls", True
It runs, but there's no data in the spreadsheet. What am I missing?
Thanks for your help.
 
Are you checking all the sheets in the new workbook? When exporting, Access
makes a new worksheet, in this case called "TestTable" and that's where the
data resides.

Sam
 
Well, I'll be! There they are. Thank you, Sam!

OfficeDev18 via AccessMonster.com said:
Are you checking all the sheets in the new workbook? When exporting, Access
makes a new worksheet, in this case called "TestTable" and that's where the
data resides.

Sam
Click to expand...
 
Back
Top