UtterAccess Discussion Forums > Exporting to excel from access database

Full Version: Exporting to excel from access database

UtterAccess Discussion Forums > Microsoft® Access > Access Automation

Reeni

Jun 22 2004, 08:58 AM

Hi

I have been struggling with exporting 8 tables from access onto one excel spreadsheet..
I am getting error message the object cannot be found

this is the code for one of the queries that are not exporting to exce.

'DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Qu_6", "H:\My Documents\Rent_Test.xls", True, "A16:H23"

'DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Qu_22", "H:\My Documents\Rent_Test.xls", True, "A48:H55"

thanks in advance

R

PaulDavies

Jun 22 2004, 09:05 AM

the Range argument only applies to importing. I do not believe you can export to a portion of a spreadsheet

Paul

This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.